https://community.qlik.com/t5/Talend-Studio/Merging-and-concatenate-rows-values/m-p/2309641#M80839 Looks like GROUP BY operation. I suggest you do it in your database if you are getting the records from database.<BR /><BR />You can also check the tAggregateRow component Wed, 15 May 2019 15:34:17 GMT Anonymous 2019-05-15T15:34:17Z https://community.qlik.com/t5/Talend-Studio/Merging-and-concatenate-rows-values/m-p/2309640#M80838 <P>Hello,</P> <P>&nbsp;</P> <P>I have a job which create the output as bellow :</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rows.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M4bJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137155i62DB6DADFF24C117/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M4bJ.png" alt="0683p000009M4bJ.png" /></span></SPAN></P> <P>&nbsp;</P> <P>I want to get this output :</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="row2.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M4Yf.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138005i1BDB0697EC04A154/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M4Yf.png" alt="0683p000009M4Yf.png" /></span></SPAN></P> <P>&nbsp;</P> <P>The operations are the concatenation for the first column values and merging all the first rows values to the second one (A01 to B01 and A02 to B02).</P> <P>&nbsp;</P> <P>Rows are memorized 2 by 2 using tMemorizeRows module. The other modules that I use are tFlexJava, tMap...</P> <P>&nbsp;</P> <P>A help will be much appreciate.</P> <P>&nbsp;</P> <P>Thank you!</P> Sat, 16 Nov 2024 05:49:49 GMT https://community.qlik.com/t5/Talend-Studio/Merging-and-concatenate-rows-values/m-p/2309640#M80838 Anonymous 2024-11-16T05:49:49Z https://community.qlik.com/t5/Talend-Studio/Merging-and-concatenate-rows-values/m-p/2309641#M80839 Looks like GROUP BY operation. I suggest you do it in your database if you are getting the records from database.<BR /><BR />You can also check the tAggregateRow component Wed, 15 May 2019 15:34:17 GMT https://community.qlik.com/t5/Talend-Studio/Merging-and-concatenate-rows-values/m-p/2309641#M80839 Anonymous 2019-05-15T15:34:17Z