rows not generated during create table if does not exist
My job is tMysqlconnection-->tFileExcelInput-->tMap-->tMysqloutput. I have given "auto-commit" in tMysqlconnection and connected to input and mapped properly in tMap and in tMysqloutput i have give use existing connection and directory correctly.In MySql only the table is generated but not rows.Could please help me in solving this issue.It is throwing "Data truncation: Data too long for column at row 1" this error.
This will be due to either their being no value in the length column of a column in your schema OR the fact that your data is too big to fit given the length settings.
