Hello,
I'm quite new on Talend and I'm looking for a solution to split a file containing a large list of ids into several rows. My input file is a csv containing 1 row with a list of thousands of ids delimited by a comma :
id1, id2, id3, ... idn.
I need to split the list into several rows containing a maximum of 100 ids :
id1, ... id100
id101, ... id200
etc.
I don't know how to handle this. Maybe someone could give me some clues ?
Hi
erwan_ln,
There is an option 'Split output in several files' in the advanced setting tab of tFileOutputDelimited. You can generate N rows in each file.