topic Re: How to achieve this kinda transpose? in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227186#M18873 <P>Can anyone help me with the same?</P> Sat, 20 Jul 2019 15:53:20 GMT Anonymous 2019-07-20T15:53:20Z How to achieve this kinda transpose? https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227183#M18870 <P>Hi All,&nbsp;</P> <P>Here is my input and output, i'm not sure how to achieve this kind of output.</P> <P>My source is an excel file, is there a way i can read specific field in an excel?</P> <P>&nbsp;</P> <P>Input:&nbsp;</P> <TABLE> <TBODY> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>Store1</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>2001</TD> <TD>5003</TD> <TD>4002</TD> <TD>703</TD> </TR> <TR> <TD>Item</TD> <TD>Code</TD> <TD>Price1</TD> <TD>Price2</TD> <TD>Price3</TD> <TD>Price4</TD> </TR> <TR> <TD>Oranges</TD> <TD>1</TD> <TD>100</TD> <TD>120</TD> <TD>130</TD> <TD>140</TD> </TR> <TR> <TD>Apples</TD> <TD>2</TD> <TD>180</TD> <TD>190</TD> <TD>195</TD> <TD>200</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Output :&nbsp;</P> <TABLE> <TBODY> <TR> <TD>Item</TD> <TD>Code</TD> <TD>Range</TD> <TD>Store_Code</TD> <TD>Store_Name</TD> <TD>Amount</TD> </TR> <TR> <TD>Oranges</TD> <TD>1</TD> <TD>Price1</TD> <TD>2001</TD> <TD>Store1</TD> <TD>100</TD> </TR> <TR> <TD>Oranges</TD> <TD>1</TD> <TD>Price2</TD> <TD>5003</TD> <TD>Store1</TD> <TD>120</TD> </TR> <TR> <TD>Oranges</TD> <TD>1</TD> <TD>Price3</TD> <TD>4002</TD> <TD>Store1</TD> <TD>130</TD> </TR> <TR> <TD>Oranges</TD> <TD>1</TD> <TD>Price4</TD> <TD>703</TD> <TD>Store1</TD> <TD>140</TD> </TR> <TR> <TD>Apples</TD> <TD>2</TD> <TD>Price1</TD> <TD>2001</TD> <TD>Store1</TD> <TD>180</TD> </TR> <TR> <TD>Apples</TD> <TD>2</TD> <TD>Price2</TD> <TD>5003</TD> <TD>Store1</TD> <TD>190</TD> </TR> <TR> <TD>Apples</TD> <TD>2</TD> <TD>Price3</TD> <TD>4002</TD> <TD>Store1</TD> <TD>195</TD> </TR> <TR> <TD>Apples</TD> <TD>2</TD> <TD>Price4</TD> <TD>703</TD> <TD>Store1</TD> <TD>200</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Appreciate your help.</P> <P>Thanks</P> Sat, 16 Nov 2024 05:17:41 GMT https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227183#M18870 Anonymous 2024-11-16T05:17:41Z Re: How to achieve this kinda transpose? https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227184#M18871 <P>Take a look at this article</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>&nbsp;</P><P>What you are trying to do is called a pivot or unpivot.</P> Sat, 13 Jul 2019 06:16:32 GMT https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227184#M18871 nfz11 2019-07-13T06:16:32Z Re: How to achieve this kinda transpose? https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227185#M18872 <P>Thanks for the reply.</P><P>&nbsp;</P><P>But if you notice closely, we have another column to generate for store and store_code.</P><P>Which is the tricky part.&nbsp;</P><P>&nbsp;</P><P>And is there where we can read excel data from specific cell?</P><P>&nbsp;</P><P>Cheers!</P> Mon, 15 Jul 2019 07:02:29 GMT https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227185#M18872 Anonymous 2019-07-15T07:02:29Z Re: How to achieve this kinda transpose? https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227186#M18873 <P>Can anyone help me with the same?</P> Sat, 20 Jul 2019 15:53:20 GMT https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227186#M18873 Anonymous 2019-07-20T15:53:20Z Re: How to achieve this kinda transpose? https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227187#M18874 <P>Look at the *Excel* components.&nbsp; This doc might help you:</P> <P><A href="https://community.qlik.com/s/feed/0D53p00007vCkHXCA0" target="_blank">https://community.talend.com/t5/Design-and-Development/how-to-extract-a-value-of-a-cell-in-the-excel-with/td-p/72983</A></P> Wed, 24 Jul 2019 18:57:44 GMT https://community.qlik.com/t5/Talend-Studio/How-to-achieve-this-kinda-transpose/m-p/2227187#M18874 nfz11 2019-07-24T18:57:44Z