One Star

split a file in several rows

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 ? Smiley Happy

I would like
1 REPLY
Moderator

Re: split a file in several rows

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.

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.