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 ?
I would like