topic Re: transpose column values into row values in Talend Studio https://community.qlik.com/t5/Talend-Studio/transpose-column-values-into-row-values/m-p/2369916#M133018 Hi,<BR />Please take a look at&nbsp;<A href="https://help.talend.com/search/all?query=tNormalize" target="_blank" rel="nofollow noopener noreferrer">TalendHelpCenter:tNormalize</A>&nbsp;component which n<FONT size="2"><FONT face="noto," helvetica="">ormalizes the input flow following SQL standard.</FONT></FONT><BR />[font=noto, Helvetica, Arial, sans-serif]<FONT size="2">Best regards</FONT>[/font]<BR />[font=noto, Helvetica, Arial, sans-serif]<FONT size="2">Sabrina</FONT>[/font] Fri, 13 May 2016 04:06:24 GMT Anonymous 2016-05-13T04:06:24Z transpose column values into row values https://community.qlik.com/t5/Talend-Studio/transpose-column-values-into-row-values/m-p/2369915#M133017 <P>Hi all,<BR />I'm a newbie,pls help me out to convert<BR />my input<BR />c1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c4<BR />M1,M3,M4,M6 &nbsp; &nbsp;0.685846988,0.919621311,0.99116034,0.338322162 &nbsp;0.536476537,0.304836384,0.624345034,0.045164593&nbsp;<BR /><BR />&nbsp;0.011237709,0.897359576,0.216382079,0.84172398<BR /><BR /><FONT color="#000000">&nbsp;</FONT>output should be<BR /><BR /><FONT color="black">M1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; M3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; M4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; M6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</FONT><BR /><FONT color="black">0.685846988&nbsp;&nbsp;&nbsp;&nbsp; 0.919621311&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0.99116034&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0.338322162 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</FONT><BR /><FONT color="black">0.536476537&nbsp;&nbsp;&nbsp;&nbsp; 0.304836384&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0.624345034&nbsp; &nbsp; &nbsp; &nbsp;0.045164593 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</FONT><BR /><FONT color="black">0.011237709 &nbsp; &nbsp; 0.897359576 &nbsp; &nbsp; &nbsp; &nbsp;0.216382079&nbsp; &nbsp; &nbsp; &nbsp;0.84172398 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</FONT><BR /><FONT color="black">0.906233083</FONT><FONT color="black">&nbsp; &nbsp; &nbsp;</FONT><FONT color="black">0.439797637</FONT><FONT color="black">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</FONT><FONT color="black">0.055043695</FONT><FONT color="black">&nbsp; &nbsp; &nbsp; </FONT><FONT color="black">0.26720812</FONT><FONT color="black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT><FONT color="black">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</FONT><BR /><BR /><FONT color="black">I have tried tpivotdelimited,tnormalize,tdenormalize,taggregateroew.Pls help me I don't know where I'm doing wrong..</FONT><BR /><BR /><BR /><FONT color="black">Any suggestion...Thanks in advance</FONT><BR /><BR /><BR /><FONT color="black">Thanks&nbsp;</FONT><BR /><FONT color="black">VK</FONT></P> Tue, 10 May 2016 12:22:45 GMT https://community.qlik.com/t5/Talend-Studio/transpose-column-values-into-row-values/m-p/2369915#M133017 Anonymous 2016-05-10T12:22:45Z Re: transpose column values into row values https://community.qlik.com/t5/Talend-Studio/transpose-column-values-into-row-values/m-p/2369916#M133018 Hi,<BR />Please take a look at&nbsp;<A href="https://help.talend.com/search/all?query=tNormalize" target="_blank" rel="nofollow noopener noreferrer">TalendHelpCenter:tNormalize</A>&nbsp;component which n<FONT size="2"><FONT face="noto," helvetica="">ormalizes the input flow following SQL standard.</FONT></FONT><BR />[font=noto, Helvetica, Arial, sans-serif]<FONT size="2">Best regards</FONT>[/font]<BR />[font=noto, Helvetica, Arial, sans-serif]<FONT size="2">Sabrina</FONT>[/font] Fri, 13 May 2016 04:06:24 GMT https://community.qlik.com/t5/Talend-Studio/transpose-column-values-into-row-values/m-p/2369916#M133018 Anonymous 2016-05-13T04:06:24Z