https://community.qlik.com/t5/Talend-Studio/convert-row-data-to-coloumn-wise/m-p/2366014#M129550 <P></P><P></P><P>Hi </P><P></P><P></P><P>I am getting an output like below. </P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="069U10000011kmdIAA.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152679i6FEB1C1B44CD6292/image-size/large?v=v2&amp;px=999" role="button" title="069U10000011kmdIAA.png" alt="069U10000011kmdIAA.png" /></span></P><P></P><P></P><P>expected:</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="069U10000011a94IAA.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/145068iB50FBAEDE87511BA/image-size/large?v=v2&amp;px=999" role="button" title="069U10000011a94IAA.png" alt="069U10000011a94IAA.png" /></span></P><P>please help me out </P><P></P><P></P><P></P><P></P> Tue, 12 Dec 2023 19:23:59 GMT Sbxr80 2023-12-12T19:23:59Z https://community.qlik.com/t5/Talend-Studio/convert-row-data-to-coloumn-wise/m-p/2366014#M129550 <P></P><P></P><P>Hi </P><P></P><P></P><P>I am getting an output like below. </P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="069U10000011kmdIAA.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152679i6FEB1C1B44CD6292/image-size/large?v=v2&amp;px=999" role="button" title="069U10000011kmdIAA.png" alt="069U10000011kmdIAA.png" /></span></P><P></P><P></P><P>expected:</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="069U10000011a94IAA.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/145068iB50FBAEDE87511BA/image-size/large?v=v2&amp;px=999" role="button" title="069U10000011a94IAA.png" alt="069U10000011a94IAA.png" /></span></P><P>please help me out </P><P></P><P></P><P></P><P></P> Tue, 12 Dec 2023 19:23:59 GMT https://community.qlik.com/t5/Talend-Studio/convert-row-data-to-coloumn-wise/m-p/2366014#M129550 Sbxr80 2023-12-12T19:23:59Z https://community.qlik.com/t5/Talend-Studio/convert-row-data-to-coloumn-wise/m-p/2366015#M129551 <P>Hello </P><P>Here is a scenario shows you how to achieve it. </P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="069U10000014n81IAA.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140130iEBA91BCF6809439C/image-size/large?v=v2&amp;px=999" role="button" title="069U10000014n81IAA.png" alt="069U10000014n81IAA.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="069U10000014mf0IAA.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133239i30E1BB32ACCB33E1/image-size/large?v=v2&amp;px=999" role="button" title="069U10000014mf0IAA.png" alt="069U10000014mf0IAA.png" /></span>&nbsp;</P><P>Code on tJavaRow:</P><P>output_row.line=input_row.id1+","+input_row.name1+";"+input_row.id2+","+input_row.name2+";"+input_row.id3+","+input_row.name3;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper" image-alt="069U10000014n9dIAA.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134290i54702DA04168D859/image-size/large?v=v2&amp;px=999" role="button" title="069U10000014n9dIAA.png" alt="069U10000014n9dIAA.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="069U10000014nBFIAY.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128093iCA127A5AC01FD32F/image-size/large?v=v2&amp;px=999" role="button" title="069U10000014nBFIAY.png" alt="069U10000014nBFIAY.png" /></span>&nbsp;</P><P>Hope it helps you.</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Thu, 14 Dec 2023 08:50:25 GMT https://community.qlik.com/t5/Talend-Studio/convert-row-data-to-coloumn-wise/m-p/2366015#M129551 Anonymous 2023-12-14T08:50:25Z https://community.qlik.com/t5/Talend-Studio/convert-row-data-to-coloumn-wise/m-p/2366016#M129552 <P>Thank you @Shicong Hong​&nbsp;</P> Tue, 19 Dec 2023 08:25:01 GMT https://community.qlik.com/t5/Talend-Studio/convert-row-data-to-coloumn-wise/m-p/2366016#M129552 Sbxr80 2023-12-19T08:25:01Z