topic Re: Pivot Data in Qlik Load Script in QlikView https://community.qlik.com/t5/QlikView/Pivot-Data-in-Qlik-Load-Script/m-p/34820#M787151 <HTML><HEAD></HEAD><BODY><P>Yes, can you search for the cross table?</P><P>may be this can help you</P><P></P><P><A href="https://community.qlik.com/message/1429850">Creating a new column in the script</A></P></BODY></HTML> Thu, 15 Feb 2018 20:45:26 GMT zebhashmi 2018-02-15T20:45:26Z Pivot Data in Qlik Load Script https://community.qlik.com/t5/QlikView/Pivot-Data-in-Qlik-Load-Script/m-p/34819#M787150 <HTML><HEAD></HEAD><BODY><P>Is there a way to pivot data in Qlik Load Script ?</P><P></P><P>Sample Data File:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Salary</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">MonthYear</TH></TR><TR><TD style="padding: 2px;">John</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">Jan 2018</TD></TR><TR><TD style="padding: 2px;">Berry</TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;">Feb 2018</TD></TR><TR><TD style="padding: 2px;">Claire</TD><TD style="padding: 2px;">2500</TD><TD style="padding: 2px;">Mar 2018</TD></TR><TR><TD style="padding: 2px;">John</TD><TD style="padding: 2px;">3000</TD><TD style="padding: 2px;">Feb 2018</TD></TR></TBODY></TABLE><P></P><P></P><P>Desired Output:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Jan 2018</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Feb 2018</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Mar 2018</STRONG></TH></TR><TR><TD style="padding: 2px;">John</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">3000</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Berry</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Claire</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">2500</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-Data-in-Qlik-Load-Script/m-p/34819#M787150 Anonymous 2020-11-25T16:16:04Z Re: Pivot Data in Qlik Load Script https://community.qlik.com/t5/QlikView/Pivot-Data-in-Qlik-Load-Script/m-p/34820#M787151 <HTML><HEAD></HEAD><BODY><P>Yes, can you search for the cross table?</P><P>may be this can help you</P><P></P><P><A href="https://community.qlik.com/message/1429850">Creating a new column in the script</A></P></BODY></HTML> Thu, 15 Feb 2018 20:45:26 GMT https://community.qlik.com/t5/QlikView/Pivot-Data-in-Qlik-Load-Script/m-p/34820#M787151 zebhashmi 2018-02-15T20:45:26Z Re: Pivot Data in Qlik Load Script https://community.qlik.com/t5/QlikView/Pivot-Data-in-Qlik-Load-Script/m-p/34821#M787152 <HTML><HEAD></HEAD><BODY><P>Hi abhay,</P><P></P><P>Please find you desire output and also, find attached qvw file for more details.</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193612_Capture.JPG" style="height: auto;" /></P><P></P><P>Regards</P><P>Ahmar</P></BODY></HTML> Fri, 16 Feb 2018 12:09:21 GMT https://community.qlik.com/t5/QlikView/Pivot-Data-in-Qlik-Load-Script/m-p/34821#M787152 ahmar811 2018-02-16T12:09:21Z Re: Pivot Data in Qlik Load Script https://community.qlik.com/t5/QlikView/Pivot-Data-in-Qlik-Load-Script/m-p/34822#M787153 <HTML><HEAD></HEAD><BODY><P>Please check below link - You have to apply Generic Load</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic">https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic</A></P><P></P><P>Thanks.</P></BODY></HTML> Fri, 16 Feb 2018 13:26:35 GMT https://community.qlik.com/t5/QlikView/Pivot-Data-in-Qlik-Load-Script/m-p/34822#M787153 isingh30 2018-02-16T13:26:35Z