topic Re: RE:How to load this Data? in QlikView https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211497#M874048 <HTML><HEAD></HEAD><BODY><P>Have you tried using gysbert's sample here?</P><P><A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P></BODY></HTML> Mon, 07 Nov 2016 12:25:59 GMT sunny_talwar 2016-11-07T12:25:59Z RE:How to load this Data? https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211496#M874047 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have data like below format how to load this type of data?</P><P></P><P>can anyone explain in detail.</P><P></P><P></P><P>Chanty</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211496#M874047 Chanty4u 2020-11-25T16:16:04Z Re: RE:How to load this Data? https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211497#M874048 <HTML><HEAD></HEAD><BODY><P>Have you tried using gysbert's sample here?</P><P><A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P></BODY></HTML> Mon, 07 Nov 2016 12:25:59 GMT https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211497#M874048 sunny_talwar 2016-11-07T12:25:59Z Re: RE:How to load this Data? https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211498#M874049 <HTML><HEAD></HEAD><BODY><P>yes.still am unable to achieve this <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Mon, 07 Nov 2016 14:12:18 GMT https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211498#M874049 Chanty4u 2016-11-07T14:12:18Z Re: RE:How to load this Data? https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211499#M874050 <HTML><HEAD></HEAD><BODY><P>Hi Chanty,</P><P>may be :</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> <SPAN style="color: #800000;">F1</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">Product</SPAN>, <BR /> <SPAN style="color: #800000;">Qu</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">Open_Qu</SPAN>, <BR /> <SPAN style="color: #800000;">Ra</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">Open_Ra</SPAN>, <BR /> <SPAN style="color: #800000;">Val</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">Open_Val</SPAN>, <BR /> <SPAN style="color: #800000;">Qu1</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">InValue_Qu</SPAN>, <BR /> <SPAN style="color: #800000;">Ra1</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">InValue_Ra</SPAN>, <BR /> <SPAN style="color: #800000;">Val1</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">InValue_Val</SPAN>, <BR /> <SPAN style="color: #800000;">Qu2</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">OutValue_Qu</SPAN>, <BR /> <SPAN style="color: #800000;">Ra2</SPAN>&nbsp; <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">OutValue_Ra</SPAN>, <BR /> <SPAN style="color: #800000;">Val2</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">OutValue_Val</SPAN>, <BR /> <SPAN style="color: #800000;">gvalue</SPAN><BR /> <SPAN style="color: #0000ff;">FROM</SPAN><BR /><SPAN> "</SPAN><A class="" data-containerid="-1" data-containertype="-1" data-objectid="252646" data-objecttype="13" href="https://community.qlik.com/servlet/JiveServlet/download/2003-238901-1155194-252646/sreg.xlsx">https://community.qlik.com/servlet/JiveServlet/download/1155194-252646/sreg.xlsx</A><SPAN>"</SPAN><BR /> (<SPAN style="color: #0000ff;">ooxml</SPAN>, <SPAN style="color: #0000ff;">embedded</SPAN> <SPAN style="color: #0000ff;">labels</SPAN>, <SPAN style="color: #0000ff;">header</SPAN> <SPAN style="color: #0000ff;">is</SPAN> 1 <SPAN style="color: #0000ff;">lines</SPAN>, <SPAN style="color: #0000ff;">table</SPAN> <SPAN style="color: #0000ff;">is</SPAN></SPAN><SPAN style="font-size: 10pt;"> Sheet1); </SPAN></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143118_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P><P></P><P></P><P></P></BODY></HTML> Mon, 07 Nov 2016 14:46:52 GMT https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211499#M874050 antoniotiman 2016-11-07T14:46:52Z Re: RE:How to load this Data? https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211500#M874051 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks for your reply.</P><P>Can you share that sample Qvw ?</P></BODY></HTML> Tue, 08 Nov 2016 09:34:49 GMT https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211500#M874051 Chanty4u 2016-11-08T09:34:49Z Re: RE:How to load this Data? https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211501#M874052 <HTML><HEAD></HEAD><BODY><P>See Attachment.</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Tue, 08 Nov 2016 09:40:46 GMT https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211501#M874052 antoniotiman 2016-11-08T09:40:46Z Re: RE:How to load this Data? https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211502#M874053 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi suresh,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">find attached using <A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P><P><A href="https://community.qlik.com/docs/DOC-4527"></A></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143232_Capture.JPG" style="height: 301px; width: 620px;" /></P></BODY></HTML> Tue, 08 Nov 2016 11:33:43 GMT https://community.qlik.com/t5/QlikView/RE-How-to-load-this-Data/m-p/1211502#M874053 settu_periasamy 2016-11-08T11:33:43Z