I am trying to split a Mysql table based on a date column. If there are n distinct dates in the input table, n different tables must be created with the table name as filesplit_<date> for e.g : filesplit_2016-01-01.
My job designer has the components linked as in the screenshot attached SplitTable1.PNG.
The output tables are created but, it only takes in 1 row as input. This problem does not arise when I save the outputs in csv files.
Thank you for the reply.
I got a solution to this. Please find it in the link https://stackoverflow.com/questions/38921621/how-to-catch-errors-and-send-them-in-an-email-using-tal...