Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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 ? 0683p000009MACn.png

I would like
Labels (2)
1 Reply
Anonymous
Not applicable

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
0683p000009MDxb.png