https://community.qlik.com/t5/App-Development/Data-Transformation-in-Load-Script/m-p/1849251#M70193 <P><A href="https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm" target="_blank">https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm</A></P> <P>Crosstable and Generic Loads are opposites, so this should be what you're after.</P> Wed, 20 Oct 2021 08:25:54 GMT Or 2021-10-20T08:25:54Z https://community.qlik.com/t5/App-Development/Data-Transformation-in-Load-Script/m-p/1849215#M70185 <P>Hi all,</P> <P>I have a query related to Qliksense.</P> <P>I want to convert below data, which I receive in excel (It's a pivot table output but I don't have the access to raw data) :</P> <TABLE width="283"> <TBODY> <TR> <TD width="74">Row Labels</TD> <TD width="29">Jan</TD> <TD width="29">Feb</TD> <TD width="31">Mar</TD> <TD width="29">Apr</TD> <TD width="33">May</TD> <TD width="29">Jun</TD> <TD width="29">Jul</TD> </TR> <TR> <TD>A</TD> <TD>458</TD> <TD>776</TD> <TD>932</TD> <TD>846</TD> <TD>872</TD> <TD>569</TD> <TD>932</TD> </TR> <TR> <TD>B</TD> <TD>920</TD> <TD>771</TD> <TD>319</TD> <TD>601</TD> <TD>346</TD> <TD>923</TD> <TD>174</TD> </TR> <TR> <TD>C</TD> <TD>375</TD> <TD>736</TD> <TD>184</TD> <TD>267</TD> <TD>586</TD> <TD>556</TD> <TD>870</TD> </TR> <TR> <TD>D</TD> <TD>285</TD> <TD>911</TD> <TD>785</TD> <TD>601</TD> <TD>195</TD> <TD>599</TD> <TD>740</TD> </TR> <TR> <TD>E</TD> <TD>804</TD> <TD>708</TD> <TD>816</TD> <TD>995</TD> <TD>165</TD> <TD>788</TD> <TD>896</TD> </TR> <TR> <TD>F</TD> <TD>555</TD> <TD>500</TD> <TD>874</TD> <TD>781</TD> <TD>231</TD> <TD>936</TD> <TD>538</TD> </TR> <TR> <TD>G</TD> <TD>463</TD> <TD>617</TD> <TD>264</TD> <TD>422</TD> <TD>320</TD> <TD>314</TD> <TD>899</TD> </TR> <TR> <TD>H</TD> <TD>478</TD> <TD>919</TD> <TD>844</TD> <TD>106</TD> <TD>789</TD> <TD>468</TD> <TD>336</TD> </TR> <TR> <TD>I</TD> <TD>801</TD> <TD>689</TD> <TD>494</TD> <TD>115</TD> <TD>103</TD> <TD>381</TD> <TD>111</TD> </TR> <TR> <TD>J</TD> <TD>612</TD> <TD>473</TD> <TD>891</TD> <TD>920</TD> <TD>638</TD> <TD>410</TD> <TD>631</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want to convert it to below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Anku_0-1634711711611.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/64794i231907E7B578E0C7/image-size/medium?v=v2&amp;px=400" role="button" title="Anku_0-1634711711611.png" alt="Anku_0-1634711711611.png" /></span></P> <P>&nbsp;</P> <P>.</P> <P>.</P> <P>.</P> <P>till Dec.</P> <P>I tried reading solution on:</P> <P><A href="https://community.qlik.com/thread/112003" target="_blank">https://community.qlik.com/thread/112003</A></P> <P>but content is not available,</P> <P>then I went through generic load:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470</A></P> <P>It was helpful but the output I am looking for is opposite of it.</P> <P>Please suggest!</P> <P>&nbsp;</P> Wed, 20 Oct 2021 06:36:05 GMT https://community.qlik.com/t5/App-Development/Data-Transformation-in-Load-Script/m-p/1849215#M70185 Anku 2021-10-20T06:36:05Z https://community.qlik.com/t5/App-Development/Data-Transformation-in-Load-Script/m-p/1849251#M70193 <P><A href="https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm" target="_blank">https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm</A></P> <P>Crosstable and Generic Loads are opposites, so this should be what you're after.</P> Wed, 20 Oct 2021 08:25:54 GMT https://community.qlik.com/t5/App-Development/Data-Transformation-in-Load-Script/m-p/1849251#M70193 Or 2021-10-20T08:25:54Z