Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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