topic How to Transpose table on the script level? in App Development

topic How to Transpose table on the script level? in App Development https://community.qlik.com/t5/App-Development/How-to-Transpose-table-on-the-script-level/m-p/1899245#M74226 <P>Hi ,</P> <P>How do we transpose the table on the script level?</P> <P>Load dimension 1,dimension 2,dimension 3,Value,Week from Table1</P> <P>Below is the table </P> <TABLE width="391px"> <TBODY> <TR> <TD width="81.9844px">dimension 1</TD> <TD width="82.9688px">dimension 2</TD> <TD width="82.9688px">dimension 3</TD> <TD width="82.2969px">Value</TD> <TD width="59.7812px">Week</TD> </TR> <TR> <TD width="81.9844px">123</TD> <TD width="82.9688px">abc</TD> <TD width="82.9688px">12ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W1</TD> </TR> <TR> <TD width="81.9844px">234</TD> <TD width="82.9688px">def</TD> <TD width="82.9688px">13ab</TD> <TD width="82.2969px">XX</TD> <TD width="59.7812px">W2</TD> </TR> <TR> <TD width="81.9844px">345</TD> <TD width="82.9688px">tre</TD> <TD width="82.9688px">14ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W1</TD> </TR> <TR> <TD width="81.9844px">456</TD> <TD width="82.9688px">euw</TD> <TD width="82.9688px">15ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W2</TD> </TR> <TR> <TD width="81.9844px">567</TD> <TD width="82.9688px">hdj</TD> <TD width="82.9688px">16ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W1</TD> </TR> <TR> <TD width="81.9844px">678</TD> <TD width="82.9688px">dsj</TD> <TD width="82.9688px">17ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W2</TD> </TR> <TR> <TD width="81.9844px">789</TD> <TD width="82.9688px">dhma</TD> <TD width="82.9688px">18ab</TD> <TD width="82.2969px">XX</TD> <TD width="59.7812px">W1</TD> </TR> <TR> <TD width="81.9844px">900</TD> <TD width="82.9688px">ksd</TD> <TD width="82.9688px">10ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W2</TD> </TR> <TR> <TD width="81.9844px">1011</TD> <TD width="82.9688px">hcd</TD> <TD width="82.9688px">10ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W1</TD> </TR> <TR> <TD width="81.9844px">1011</TD> <TD width="82.9688px">hcd</TD> <TD width="82.9688px">10ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W2</TD> </TR> </TBODY> </TABLE> <P> </P> <P> </P> <P>This is the required output</P> <TABLE width="377"> <TBODY> <TR> <TD width="83">dimension 1</TD> <TD width="83">dimension 2</TD> <TD width="83">dimension 3</TD> <TD width="64">W1</TD> <TD width="64">W2</TD> </TR> <TR> <TD>123</TD> <TD>abc</TD> <TD>12ab</TD> <TD>PG</TD> <TD> </TD> </TR> <TR> <TD>234</TD> <TD>def</TD> <TD>13ab</TD> <TD> </TD> <TD>XX</TD> </TR> <TR> <TD>345</TD> <TD>tre</TD> <TD>14ab</TD> <TD>PG</TD> <TD> </TD> </TR> <TR> <TD>456</TD> <TD>euw</TD> <TD>15ab</TD> <TD> </TD> <TD>PG</TD> </TR> <TR> <TD>567</TD> <TD>hdj</TD> <TD>16ab</TD> <TD>PG</TD> <TD> </TD> </TR> <TR> <TD>678</TD> <TD>dsj</TD> <TD>17ab</TD> <TD> </TD> <TD>PG</TD> </TR> <TR> <TD>789</TD> <TD>dhma</TD> <TD>18ab</TD> <TD>XX</TD> <TD> </TD> </TR> <TR> <TD>900</TD> <TD>ksd</TD> <TD>10ab</TD> <TD> </TD> <TD>PG</TD> </TR> <TR> <TD>1011</TD> <TD>hcd</TD> <TD>10ab</TD> <TD>PG</TD> <TD>PG</TD> </TR> </TBODY> </TABLE> Wed, 02 Mar 2022 11:27:08 GMT userpd_2021 2022-03-02T11:27:08Z How to Transpose table on the script level? https://community.qlik.com/t5/App-Development/How-to-Transpose-table-on-the-script-level/m-p/1899245#M74226 <P>Hi ,</P> <P>How do we transpose the table on the script level?</P> <P>Load dimension 1,dimension 2,dimension 3,Value,Week from Table1</P> <P>Below is the table </P> <TABLE width="391px"> <TBODY> <TR> <TD width="81.9844px">dimension 1</TD> <TD width="82.9688px">dimension 2</TD> <TD width="82.9688px">dimension 3</TD> <TD width="82.2969px">Value</TD> <TD width="59.7812px">Week</TD> </TR> <TR> <TD width="81.9844px">123</TD> <TD width="82.9688px">abc</TD> <TD width="82.9688px">12ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W1</TD> </TR> <TR> <TD width="81.9844px">234</TD> <TD width="82.9688px">def</TD> <TD width="82.9688px">13ab</TD> <TD width="82.2969px">XX</TD> <TD width="59.7812px">W2</TD> </TR> <TR> <TD width="81.9844px">345</TD> <TD width="82.9688px">tre</TD> <TD width="82.9688px">14ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W1</TD> </TR> <TR> <TD width="81.9844px">456</TD> <TD width="82.9688px">euw</TD> <TD width="82.9688px">15ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W2</TD> </TR> <TR> <TD width="81.9844px">567</TD> <TD width="82.9688px">hdj</TD> <TD width="82.9688px">16ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W1</TD> </TR> <TR> <TD width="81.9844px">678</TD> <TD width="82.9688px">dsj</TD> <TD width="82.9688px">17ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W2</TD> </TR> <TR> <TD width="81.9844px">789</TD> <TD width="82.9688px">dhma</TD> <TD width="82.9688px">18ab</TD> <TD width="82.2969px">XX</TD> <TD width="59.7812px">W1</TD> </TR> <TR> <TD width="81.9844px">900</TD> <TD width="82.9688px">ksd</TD> <TD width="82.9688px">10ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W2</TD> </TR> <TR> <TD width="81.9844px">1011</TD> <TD width="82.9688px">hcd</TD> <TD width="82.9688px">10ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W1</TD> </TR> <TR> <TD width="81.9844px">1011</TD> <TD width="82.9688px">hcd</TD> <TD width="82.9688px">10ab</TD> <TD width="82.2969px">PG</TD> <TD width="59.7812px">W2</TD> </TR> </TBODY> </TABLE> <P> </P> <P> </P> <P>This is the required output</P> <TABLE width="377"> <TBODY> <TR> <TD width="83">dimension 1</TD> <TD width="83">dimension 2</TD> <TD width="83">dimension 3</TD> <TD width="64">W1</TD> <TD width="64">W2</TD> </TR> <TR> <TD>123</TD> <TD>abc</TD> <TD>12ab</TD> <TD>PG</TD> <TD> </TD> </TR> <TR> <TD>234</TD> <TD>def</TD> <TD>13ab</TD> <TD> </TD> <TD>XX</TD> </TR> <TR> <TD>345</TD> <TD>tre</TD> <TD>14ab</TD> <TD>PG</TD> <TD> </TD> </TR> <TR> <TD>456</TD> <TD>euw</TD> <TD>15ab</TD> <TD> </TD> <TD>PG</TD> </TR> <TR> <TD>567</TD> <TD>hdj</TD> <TD>16ab</TD> <TD>PG</TD> <TD> </TD> </TR> <TR> <TD>678</TD> <TD>dsj</TD> <TD>17ab</TD> <TD> </TD> <TD>PG</TD> </TR> <TR> <TD>789</TD> <TD>dhma</TD> <TD>18ab</TD> <TD>XX</TD> <TD> </TD> </TR> <TR> <TD>900</TD> <TD>ksd</TD> <TD>10ab</TD> <TD> </TD> <TD>PG</TD> </TR> <TR> <TD>1011</TD> <TD>hcd</TD> <TD>10ab</TD> <TD>PG</TD> <TD>PG</TD> </TR> </TBODY> </TABLE> Wed, 02 Mar 2022 11:27:08 GMT https://community.qlik.com/t5/App-Development/How-to-Transpose-table-on-the-script-level/m-p/1899245#M74226 userpd_2021 2022-03-02T11:27:08Z Re: How to Transpose table on the script level? https://community.qlik.com/t5/App-Development/How-to-Transpose-table-on-the-script-level/m-p/1899251#M74228 <P>Have a look at previous answers to the question of pivoting in script:</P> <P><A href="https://community.qlik.com/t5/App-Development/how-to-pivot-in-load-script/td-p/1513761" target="_blank">https://community.qlik.com/t5/App-Development/how-to-pivot-in-load-script/td-p/1513761</A></P> <P><A href="https://community.qlik.com/t5/New-to-Qlik-Sense/transposing-pivoting-in-the-data-load-editor/td-p/1568293" target="_blank">https://community.qlik.com/t5/New-to-Qlik-Sense/transposing-pivoting-in-the-data-load-editor/td-p/1568293</A></P> <P><A href="https://community.qlik.com/t5/QlikView-App-Dev/Pivot-Data-in-Qlik-Load-Script/td-p/34819" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/Pivot-Data-in-Qlik-Load-Script/td-p/34819</A></P> Wed, 02 Mar 2022 11:40:40 GMT https://community.qlik.com/t5/App-Development/How-to-Transpose-table-on-the-script-level/m-p/1899251#M74228 Or 2022-03-02T11:40:40Z Re: How to Transpose table on the script level? https://community.qlik.com/t5/App-Development/How-to-Transpose-table-on-the-script-level/m-p/1900442#M74297 <P>Something like these</P> <P>if ("Week"='W1',Value) AS W1,<BR />if ("Week"='W2',Value) AS W2</P> <P> </P> <P> </P> Thu, 03 Mar 2022 09:12:22 GMT https://community.qlik.com/t5/App-Development/How-to-Transpose-table-on-the-script-level/m-p/1900442#M74297 MohammedMustaq 2022-03-03T09:12:22Z