topic Re: pivot in Talend Studio https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241459#M28601 <P><A href="https://community.qlik.com/s/profile/0053p000007LQWSAA4">@saravanan_ehkn</A>&nbsp;,check the below example.</P> <P>&nbsp;</P> <P><A href="https://community.qlik.com/s/article/ka03p0000006EZhAAM" target="_blank">https://community.talend.com/t5/Migration-Configuration-and/Converting-columns-to-rows/ta-p/21658</A></P> Wed, 06 Nov 2019 12:19:07 GMT manodwhb 2019-11-06T12:19:07Z pivot https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241458#M28600 <P><STRONG>&nbsp;Transpose the columns to rows</STRONG></P><P>&nbsp;</P><P><STRONG>&nbsp;Input:</STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</STRONG></P><TABLE><TBODY><TR><TD><P>&nbsp;Name</P></TD><TD><P>English</P></TD><TD><P>Tamil</P></TD><TD><P>maths</P></TD></TR><TR><TD><P>AA</P></TD><TD><P>60</P></TD><TD><P>80</P></TD><TD><P>90</P></TD></TR><TR><TD><P>BB</P></TD><TD><P>88</P></TD><TD><P>76</P></TD><TD><P>99</P></TD></TR><TR><TD><P>CC</P></TD><TD><P>85</P></TD><TD><P>90</P></TD><TD><P>88</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P><STRONG>Output</STRONG></P><TABLE><TBODY><TR><TD><P>&nbsp;Name</P></TD><TD><P>Subject</P></TD><TD><P>Mark</P></TD></TR><TR><TD><P>&nbsp;AA</P></TD><TD><P>English</P></TD><TD><P>60</P></TD></TR><TR><TD><P>AA</P></TD><TD><P>Tamil</P></TD><TD><P>80</P></TD></TR><TR><TD><P>AA</P></TD><TD><P>maths</P></TD><TD><P>90</P></TD></TR><TR><TD><P>BB</P></TD><TD><P>English</P></TD><TD><P>88</P></TD></TR><TR><TD><P>BB</P></TD><TD><P>Tamil</P></TD><TD><P>76</P></TD></TR><TR><TD><P>BB</P></TD><TD><P>maths</P></TD><TD><P>99</P></TD></TR><TR><TD><P>CC</P></TD><TD><P>English</P></TD><TD><P>85</P></TD></TR><TR><TD><P>CC</P></TD><TD><P>Tamil</P></TD><TD><P>90</P></TD></TR><TR><TD><P>CC</P></TD><TD><P>maths</P></TD><TD><P>88</P></TD></TR></TBODY></TABLE> Wed, 06 Nov 2019 12:05:17 GMT https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241458#M28600 Anonymous 2019-11-06T12:05:17Z Re: pivot https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241459#M28601 <P><A href="https://community.qlik.com/s/profile/0053p000007LQWSAA4">@saravanan_ehkn</A>&nbsp;,check the below example.</P> <P>&nbsp;</P> <P><A href="https://community.qlik.com/s/article/ka03p0000006EZhAAM" target="_blank">https://community.talend.com/t5/Migration-Configuration-and/Converting-columns-to-rows/ta-p/21658</A></P> Wed, 06 Nov 2019 12:19:07 GMT https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241459#M28601 manodwhb 2019-11-06T12:19:07Z Re: pivot https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241460#M28602 <P><A href="https://community.qlik.com/s/profile/0053p000007LQWSAA4">@saravanan_ehkn</A>&nbsp;, you need to use custome component of tUnpivot from talend exchange and install and design the<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8NQ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151420iF18212ECDA8F65E6/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8NQ.png" alt="0683p000009M8NQ.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8QU.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147210i58F4A687B0601C1C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8QU.png" alt="0683p000009M8QU.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8Tw.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135794i30FC631BB336EA3C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8Tw.png" alt="0683p000009M8Tw.png" /></span></SPAN> job below way.</P> <P>&nbsp;</P> <P><A href="https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&amp;p=marketplace%252F1%252Fproducts%252F737&amp;pi=marketplace%252F1%252Fproducts%252F737%252Fitems%252F1043" target="_blank" rel="nofollow noopener noreferrer">https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&amp;p=marketplace%252F1%252Fproducts%252F737&amp;pi=marketplace%252F1%252Fproducts%252F737%252Fitems%252F1043</A></P> <P>&nbsp;</P> Wed, 06 Nov 2019 12:33:49 GMT https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241460#M28602 manodwhb 2019-11-06T12:33:49Z Re: pivot https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241461#M28603 <P>Thanks it's working</P><BR /><A href="https://community.qlik.com/legacyfs/online/tlnd_dw_files/0683p000009Lx6j">29_day.csv</A> Thu, 07 Nov 2019 12:22:05 GMT https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241461#M28603 Anonymous 2019-11-07T12:22:05Z Re: pivot https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241462#M28604 <P><A href="https://community.qlik.com/s/profile/0053p000007LQWSAA4">@saravanan_ehkn</A>&nbsp;,please accept the solution and also provide kudos.</P> Thu, 07 Nov 2019 12:30:18 GMT https://community.qlik.com/t5/Talend-Studio/pivot/m-p/2241462#M28604 manodwhb 2019-11-07T12:30:18Z