https://community.qlik.com/t5/Talend-Studio/Talend-Data-Integration-How-to-iterate-by-several-fields/m-p/2317591#M88019 <P>Hi, all<BR /><BR />&nbsp; I have a Excel file with some fields, such as:<BR />&nbsp;<BR />Supplier_id&nbsp;&nbsp; &nbsp;UPI_ID&nbsp;&nbsp; &nbsp;Line_id&nbsp;&nbsp; &nbsp;Description<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;A&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;1&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_x<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;A&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_xx<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;B&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;3&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_xxx<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;C&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;4&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_xxxx<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;C&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;5&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_xxxxx<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;C&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;6&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_xxxxxx<BR /><BR />&nbsp; I need to loop for each UPI_ID and then for each Line_id to get a text output field with this format:<BR /><BR />6189000;<BR />A;<BR />1;colour_x;<BR />2;colour_xx;<BR />B;<BR />3;colour_xxx;<BR />C;<BR />4;colour_xxxx;<BR />5;colour_xxxxx;<BR />6;colour_xxxxxx;<BR /><BR />(all in one line but I am writing as above just to clarify the output).<BR /><BR />&nbsp; It is really much more complex but that is the idea.<BR /><BR />Do you know how can I achive it, please?.&nbsp;&nbsp; &nbsp; &nbsp;<BR /><BR /><BR />Thanks in advance:<BR />Jose</P> Thu, 15 Mar 2018 15:18:05 GMT Anonymous 2018-03-15T15:18:05Z https://community.qlik.com/t5/Talend-Studio/Talend-Data-Integration-How-to-iterate-by-several-fields/m-p/2317591#M88019 <P>Hi, all<BR /><BR />&nbsp; I have a Excel file with some fields, such as:<BR />&nbsp;<BR />Supplier_id&nbsp;&nbsp; &nbsp;UPI_ID&nbsp;&nbsp; &nbsp;Line_id&nbsp;&nbsp; &nbsp;Description<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;A&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;1&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_x<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;A&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_xx<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;B&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;3&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_xxx<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;C&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;4&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_xxxx<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;C&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;5&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_xxxxx<BR />6189000&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;C&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;6&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;colour_xxxxxx<BR /><BR />&nbsp; I need to loop for each UPI_ID and then for each Line_id to get a text output field with this format:<BR /><BR />6189000;<BR />A;<BR />1;colour_x;<BR />2;colour_xx;<BR />B;<BR />3;colour_xxx;<BR />C;<BR />4;colour_xxxx;<BR />5;colour_xxxxx;<BR />6;colour_xxxxxx;<BR /><BR />(all in one line but I am writing as above just to clarify the output).<BR /><BR />&nbsp; It is really much more complex but that is the idea.<BR /><BR />Do you know how can I achive it, please?.&nbsp;&nbsp; &nbsp; &nbsp;<BR /><BR /><BR />Thanks in advance:<BR />Jose</P> Thu, 15 Mar 2018 15:18:05 GMT https://community.qlik.com/t5/Talend-Studio/Talend-Data-Integration-How-to-iterate-by-several-fields/m-p/2317591#M88019 Anonymous 2018-03-15T15:18:05Z