https://community.qlik.com/t5/Talend-Studio/split-a-file-in-several-rows/m-p/2362976#M126991 Hello, <BR />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 : <BR />id1, id2, id3, ... idn. <BR />I need to split the list into several rows containing a maximum of 100 ids : <BR />id1, ... id100 <BR />id101, ... id200 <BR />etc. <BR />I don't know how to handle this. Maybe someone could give me some clues ? <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR /> <BR />I would like Thu, 11 Jun 2015 09:42:54 GMT _AnonymousUser 2015-06-11T09:42:54Z https://community.qlik.com/t5/Talend-Studio/split-a-file-in-several-rows/m-p/2362976#M126991 Hello, <BR />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 : <BR />id1, id2, id3, ... idn. <BR />I need to split the list into several rows containing a maximum of 100 ids : <BR />id1, ... id100 <BR />id101, ... id200 <BR />etc. <BR />I don't know how to handle this. Maybe someone could give me some clues ? <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR /> <BR />I would like Thu, 11 Jun 2015 09:42:54 GMT https://community.qlik.com/t5/Talend-Studio/split-a-file-in-several-rows/m-p/2362976#M126991 _AnonymousUser 2015-06-11T09:42:54Z https://community.qlik.com/t5/Talend-Studio/split-a-file-in-several-rows/m-p/2362977#M126992 Hi&nbsp; <FONT color="#5b5b5d"><FONT size="1"><FONT face="Verdana, Helvetica, Arial, sans-serif">erwan_ln,</FONT></FONT></FONT> <BR /> <FONT size="1"><FONT face="Verdana, Helvetica, Arial, sans-serif">There is an option 'Split output in several files' in the advanced setting tab of tFileOutputDelimited. You can generate N rows in each file.</FONT></FONT> <BR /> <BR /> <FONT size="1"><FONT face="Verdana, Helvetica, Arial, sans-serif">Best regards</FONT></FONT> <BR /> <FONT size="1"><FONT face="Verdana, Helvetica, Arial, sans-serif">Sabrina</FONT></FONT> <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MDxb.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140122i9D5482C64CED4B02/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MDxb.png" alt="0683p000009MDxb.png" /></span> Fri, 12 Jun 2015 04:16:22 GMT https://community.qlik.com/t5/Talend-Studio/split-a-file-in-several-rows/m-p/2362977#M126992 Anonymous 2015-06-12T04:16:22Z