Solved! Go to Solution.
There is an option 'Split output in several files' in the advanced setting tab of tFileOutputDelimid. You can generate N rows in each file.
There is no "split" option in tfileoutputexcel component.
You can transfer your output delimited files into excel files.
tfileinputexcel-->tfileoututdelimited(split)-->tfilelist(loop through your splitted files)-->further processing(excel output, DB)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables