topic Re: How to transpose dynamic columns into rows when using dynamic schema in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-transpose-dynamic-columns-into-rows-when-using-dynamic/m-p/2470873#M140994 <P>Hello,</P> <P>You can achieve the expected result with a job design like below</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dave_Simo_0-1721114170340.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169405iBA1003F2D7B8089D/image-size/medium?v=v2&amp;px=400" role="button" title="Dave_Simo_0-1721114170340.png" alt="Dave_Simo_0-1721114170340.png" /></span></P> <P>Best Regards</P> Tue, 16 Jul 2024 07:17:35 GMT Dave_Simo 2024-07-16T07:17:35Z How to transpose dynamic columns into rows when using dynamic schema https://community.qlik.com/t5/Talend-Studio/How-to-transpose-dynamic-columns-into-rows-when-using-dynamic/m-p/2466289#M140881 <P>Hello everyone</P> <P>I am using&nbsp;dynamic schema to read data because the input file's column is changing dynamically.</P> <P>How to transpose dynamic columns into rows?</P> <P>Input File:</P> <TABLE border="0" cellspacing="0"> <TBODY> <TR> <TD><FONT face="Sky Text" size="1" color="#000000">Articoli</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">561</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">575</FONT></TD> </TR> <TR> <TD><FONT face="Sky Text" size="1" color="#000000">Video</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">1049</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">1161</FONT></TD> </TR> <TR> <TD><FONT face="Sky Text" size="1" color="#000000">Tot</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">1610</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">1736</FONT></TD> </TR> </TBODY> </TABLE> <P>Expected Output:</P> <TABLE border="0" cellspacing="0"> <TBODY> <TR> <TD><FONT face="Sky Text" size="1" color="#000000">Articoli</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">Video</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">Tot</FONT></TD> </TR> <TR> <TD><FONT face="Sky Text" size="1" color="#000000">561</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">1049</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">1610</FONT></TD> </TR> <TR> <TD><FONT face="Sky Text" size="1" color="#000000">575</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">1161</FONT></TD> <TD><FONT face="Sky Text" size="1" color="#000000">1736</FONT></TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Thanks in advance</P> <P>Ryu</P> Fri, 28 Jun 2024 07:53:38 GMT https://community.qlik.com/t5/Talend-Studio/How-to-transpose-dynamic-columns-into-rows-when-using-dynamic/m-p/2466289#M140881 laughsmile 2024-06-28T07:53:38Z Re: How to transpose dynamic columns into rows when using dynamic schema https://community.qlik.com/t5/Talend-Studio/How-to-transpose-dynamic-columns-into-rows-when-using-dynamic/m-p/2470873#M140994 <P>Hello,</P> <P>You can achieve the expected result with a job design like below</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dave_Simo_0-1721114170340.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169405iBA1003F2D7B8089D/image-size/medium?v=v2&amp;px=400" role="button" title="Dave_Simo_0-1721114170340.png" alt="Dave_Simo_0-1721114170340.png" /></span></P> <P>Best Regards</P> Tue, 16 Jul 2024 07:17:35 GMT https://community.qlik.com/t5/Talend-Studio/How-to-transpose-dynamic-columns-into-rows-when-using-dynamic/m-p/2470873#M140994 Dave_Simo 2024-07-16T07:17:35Z