topic Pivot column and header in the same time in Talend Studio

topic Pivot column and header in the same time in Talend Studio https://community.qlik.com/t5/Talend-Studio/Pivot-column-and-header-in-the-same-time/m-p/2286061#M59683 <P>Hello everyone, i have a problem that i couldn't solve yet and i need your help please. </P> <P> </P> <P>FYI i'm using TOS 7.3.1</P> <P>I have input data from an excel file having the following format:</P> <P> </P> <TABLE width="240"> <TBODY> <TR> <TD width="112">Transaction Type</TD> <TD width="64">2018</TD> <TD width="64">2019</TD> </TR> <TR> <TD>A</TD> <TD>150</TD> <TD>80</TD> </TR> <TR> <TD>B</TD> <TD>200</TD> <TD>254</TD> </TR> <TR> <TD>C</TD> <TD>600</TD> <TD>541</TD> </TR> <TR> <TD>D</TD> <TD>1540</TD> <TD>1550</TD> </TR> </TBODY> </TABLE> <P> </P> <P>but i need to transform it to the following format in the output </P> <P> </P> <TABLE width="240"> <TBODY> <TR> <TD width="112">Transaction</TD> <TD width="64">Year</TD> <TD width="64">Value</TD> </TR> <TR> <TD>A</TD> <TD>2018</TD> <TD>150</TD> </TR> <TR> <TD>A</TD> <TD>2019</TD> <TD>80</TD> </TR> <TR> <TD>B</TD> <TD>2018</TD> <TD>200</TD> </TR> <TR> <TD>B</TD> <TD>2019</TD> <TD>254</TD> </TR> <TR> <TD>C</TD> <TD>2018</TD> <TD>600</TD> </TR> <TR> <TD>C</TD> <TD>2019</TD> <TD>541</TD> </TR> <TR> <TD>D</TD> <TD>2018</TD> <TD>1540</TD> </TR> <TR> <TD>D</TD> <TD>2019</TD> <TD>1550</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Many thanks,</P> <P>Amine </P> <P> </P> Sat, 16 Nov 2024 02:16:08 GMT Anonymous 2024-11-16T02:16:08Z Pivot column and header in the same time https://community.qlik.com/t5/Talend-Studio/Pivot-column-and-header-in-the-same-time/m-p/2286061#M59683 <P>Hello everyone, i have a problem that i couldn't solve yet and i need your help please. </P> <P> </P> <P>FYI i'm using TOS 7.3.1</P> <P>I have input data from an excel file having the following format:</P> <P> </P> <TABLE width="240"> <TBODY> <TR> <TD width="112">Transaction Type</TD> <TD width="64">2018</TD> <TD width="64">2019</TD> </TR> <TR> <TD>A</TD> <TD>150</TD> <TD>80</TD> </TR> <TR> <TD>B</TD> <TD>200</TD> <TD>254</TD> </TR> <TR> <TD>C</TD> <TD>600</TD> <TD>541</TD> </TR> <TR> <TD>D</TD> <TD>1540</TD> <TD>1550</TD> </TR> </TBODY> </TABLE> <P> </P> <P>but i need to transform it to the following format in the output </P> <P> </P> <TABLE width="240"> <TBODY> <TR> <TD width="112">Transaction</TD> <TD width="64">Year</TD> <TD width="64">Value</TD> </TR> <TR> <TD>A</TD> <TD>2018</TD> <TD>150</TD> </TR> <TR> <TD>A</TD> <TD>2019</TD> <TD>80</TD> </TR> <TR> <TD>B</TD> <TD>2018</TD> <TD>200</TD> </TR> <TR> <TD>B</TD> <TD>2019</TD> <TD>254</TD> </TR> <TR> <TD>C</TD> <TD>2018</TD> <TD>600</TD> </TR> <TR> <TD>C</TD> <TD>2019</TD> <TD>541</TD> </TR> <TR> <TD>D</TD> <TD>2018</TD> <TD>1540</TD> </TR> <TR> <TD>D</TD> <TD>2019</TD> <TD>1550</TD> </TR> </TBODY> </TABLE> <P> </P> <P>Many thanks,</P> <P>Amine </P> <P> </P> Sat, 16 Nov 2024 02:16:08 GMT https://community.qlik.com/t5/Talend-Studio/Pivot-column-and-header-in-the-same-time/m-p/2286061#M59683 Anonymous 2024-11-16T02:16:08Z Re: Pivot column and header in the same time https://community.qlik.com/t5/Talend-Studio/Pivot-column-and-header-in-the-same-time/m-p/2286062#M59684 <P><A href="https://community.qlik.com/s/profile/0053p000007LQhDAAW">@Ameen0x</A> , check the below links.</P> <P> </P> <P><A href="https://help.talend.com/reader/Vya20tI3CbK3zEk~JdFPew/9rU5DFWIl4v9v8OwMVnu4Q" target="_blank" rel="nofollow noopener noreferrer">https://help.talend.com/reader/Vya20tI3CbK3zEk~JdFPew/9rU5DFWIl4v9v8OwMVnu4Q</A></P> <P><A href="https://community.qlik.com/s/feed/0D53p00007vCjh5CAC" target="_blank">https://community.talend.com/t5/Design-and-Development/where-to-download-tUnpivotRow-and-how-to-install-the-component/td-p/135224</A></P> Tue, 02 Jun 2020 09:18:08 GMT https://community.qlik.com/t5/Talend-Studio/Pivot-column-and-header-in-the-same-time/m-p/2286062#M59684 manodwhb 2020-06-02T09:18:08Z