Hi there, 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.
... View more