topic Re: Multiple Header Rows Data Transformation (ETL) in QlikView https://community.qlik.com/t5/QlikView/Multiple-Header-Rows-Data-Transformation-ETL/m-p/1231833#M392463 <HTML><HEAD></HEAD><BODY><P>maybe this</P><P><A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P><P>can helps you</P></BODY></HTML> Fri, 23 Dec 2016 22:56:52 GMT maxgro 2016-12-23T22:56:52Z Multiple Header Rows Data Transformation (ETL) https://community.qlik.com/t5/QlikView/Multiple-Header-Rows-Data-Transformation-ETL/m-p/1231832#M392462 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have the below table as data in excel:</P><P></P><P>TABLE1:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 624px;"><TBODY><TR><TD class="xl67" height="20" width="70"></TD><TD class="xl68" width="170">Store Name</TD><TD class="xl69" colspan="2" style="border-right: .5pt solid black;" width="128">Store I</TD><TD class="xl69" colspan="2" style="border-right: .5pt solid black; border-left: none;" width="128">Store II</TD><TD class="xl69" colspan="2" style="border-right: .5pt solid black; border-left: none;" width="128">Store III</TD></TR><TR><TD class="xl71" height="20">ProductNo</TD><TD class="xl71" style="border-left: none;">ProductName</TD><TD class="xl72" style="border-top: none; border-left: none;" width="64">Sale</TD><TD class="xl72" style="border-top: none; border-left: none;" width="64">Profit</TD><TD class="xl72" style="border-top: none; border-left: none;" width="64">Sale</TD><TD class="xl72" style="border-top: none; border-left: none;" width="64">Profit</TD><TD class="xl72" style="border-top: none; border-left: none;" width="64">Sale</TD><TD class="xl72" style="border-top: none; border-left: none;" width="64">Profit</TD></TR><TR><TD align="right" class="xl73" height="20" style="border-top: none;">1</TD><TD class="xl74" style="border-top: none; border-left: none;">ABC</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,000</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800</TD></TR><TR><TD align="right" class="xl73" height="20" style="border-top: none;">2</TD><TD class="xl76" style="border-top: none; border-left: none;">XYZ</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,000</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000</TD><TD class="xl75" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</TD></TR></TBODY></TABLE><P></P><P></P><P>Required is</P><P></P><P>RESULT:</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 348px;"><TBODY><TR><TD class="xl67" height="20" width="64">ProductNo</TD><TD class="xl67" style="border-left: none;" width="83">ProductName</TD><TD class="xl67" style="border-left: none;" width="73">Store Name</TD><TD class="xl68" style="border-left: none;" width="64">Sale</TD><TD class="xl68" style="border-left: none;" width="64">Profit</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">1</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC</TD><TD class="xl69" style="border-top: none; border-left: none;">Store I</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">2</TD><TD class="xl72" style="border-top: none; border-left: none;">XYZ</TD><TD class="xl69" style="border-top: none; border-left: none;">Store I</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,000</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">1</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC</TD><TD class="xl69" style="border-top: none; border-left: none;">Store II</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">2</TD><TD class="xl72" style="border-top: none; border-left: none;">XYZ</TD><TD class="xl69" style="border-top: none; border-left: none;">Store II</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">1</TD><TD class="xl70" style="border-top: none; border-left: none;">ABC</TD><TD class="xl69" style="border-top: none; border-left: none;">Store III</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,000</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800</TD></TR><TR><TD align="right" class="xl69" height="20" style="border-top: none;">2</TD><TD class="xl72" style="border-top: none; border-left: none;">XYZ</TD><TD class="xl69" style="border-top: none; border-left: none;">Store III</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000</TD><TD class="xl71" style="border-top: none; border-left: none;" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</TD></TR></TBODY></TABLE><P></P><P>Have a nice weekend!</P><P></P><P>Thanks and BR,</P><P>SAK</P></BODY></HTML> Fri, 23 Dec 2016 22:08:55 GMT https://community.qlik.com/t5/QlikView/Multiple-Header-Rows-Data-Transformation-ETL/m-p/1231832#M392462 Anonymous 2016-12-23T22:08:55Z Re: Multiple Header Rows Data Transformation (ETL) https://community.qlik.com/t5/QlikView/Multiple-Header-Rows-Data-Transformation-ETL/m-p/1231833#M392463 <HTML><HEAD></HEAD><BODY><P>maybe this</P><P><A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P><P>can helps you</P></BODY></HTML> Fri, 23 Dec 2016 22:56:52 GMT https://community.qlik.com/t5/QlikView/Multiple-Header-Rows-Data-Transformation-ETL/m-p/1231833#M392463 maxgro 2016-12-23T22:56:52Z Re: Multiple Header Rows Data Transformation (ETL) https://community.qlik.com/t5/QlikView/Multiple-Header-Rows-Data-Transformation-ETL/m-p/1231834#M392464 <HTML><HEAD></HEAD><BODY><P>I am using PE. Can you please post the script here?</P></BODY></HTML> Fri, 23 Dec 2016 22:57:20 GMT https://community.qlik.com/t5/QlikView/Multiple-Header-Rows-Data-Transformation-ETL/m-p/1231834#M392464 Anonymous 2016-12-23T22:57:20Z Re: Multiple Header Rows Data Transformation (ETL) https://community.qlik.com/t5/QlikView/Multiple-Header-Rows-Data-Transformation-ETL/m-p/1231835#M392465 <HTML><HEAD></HEAD><BODY><P>in the attachment </P></BODY></HTML> Fri, 23 Dec 2016 23:14:09 GMT https://community.qlik.com/t5/QlikView/Multiple-Header-Rows-Data-Transformation-ETL/m-p/1231835#M392465 maxgro 2016-12-23T23:14:09Z