topic Load Multiple Header data in qlik in QlikView

topic Load Multiple Header data in qlik in QlikView https://community.qlik.com/t5/QlikView/Load-Multiple-Header-data-in-qlik/m-p/26368#M787412 <HTML><HEAD></HEAD><BODY><P>Any idea how can attached file can be loaded into qlikview as below format. </P><P></P><P><SPAN style="font-size: 10pt;">Country,</SPAN></P><P>Manager,</P><P>Product Type,</P><P>Months,</P><P>Amount</P><P></P><P>                </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1849px;"><TBODY><TR><TD class="xl77" colspan="13" width="767">Product A</TD><TD class="xl78" colspan="13" style="border-right: 1.0pt solid black;" width="921">Product B</TD></TR><TR><TD class="xl67" height="103" width="64">Country</TD><TD class="xl68" width="73">Manager</TD><TD class="xl70">Total</TD><TD class="xl71">May</TD><TD class="xl72">Jun</TD><TD class="xl72">Jul</TD><TD class="xl72">Aug</TD><TD class="xl72">Sep</TD><TD class="xl72">Oct</TD><TD class="xl72">Nov</TD><TD class="xl72">Dec</TD><TD class="xl72">Jan</TD><TD class="xl72">Feb</TD><TD class="xl72">Mar</TD><TD class="xl73">Apr</TD><TD class="xl70">Total</TD><TD class="xl71">May</TD><TD class="xl72">Jun</TD><TD class="xl72">Jul</TD><TD class="xl72">Aug</TD><TD class="xl72">Sep</TD><TD class="xl72">Oct</TD><TD class="xl72">Nov</TD><TD class="xl72">Dec</TD><TD class="xl72">Jan</TD><TD class="xl72">Feb</TD><TD class="xl72">Mar</TD><TD class="xl73">Apr</TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 1</TD><TD align="right" class="xl76">10</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">10</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 2</TD><TD align="right" class="xl76">10</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">10</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 3</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 4</TD><TD align="right" class="xl76">22</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">22</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 5</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 6</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 7</TD><TD align="right" class="xl76">22</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">22</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mail2bsk 2020-11-25T16:16:04Z Load Multiple Header data in qlik https://community.qlik.com/t5/QlikView/Load-Multiple-Header-data-in-qlik/m-p/26368#M787412 <HTML><HEAD></HEAD><BODY><P>Any idea how can attached file can be loaded into qlikview as below format. </P><P></P><P><SPAN style="font-size: 10pt;">Country,</SPAN></P><P>Manager,</P><P>Product Type,</P><P>Months,</P><P>Amount</P><P></P><P>                </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1849px;"><TBODY><TR><TD class="xl77" colspan="13" width="767">Product A</TD><TD class="xl78" colspan="13" style="border-right: 1.0pt solid black;" width="921">Product B</TD></TR><TR><TD class="xl67" height="103" width="64">Country</TD><TD class="xl68" width="73">Manager</TD><TD class="xl70">Total</TD><TD class="xl71">May</TD><TD class="xl72">Jun</TD><TD class="xl72">Jul</TD><TD class="xl72">Aug</TD><TD class="xl72">Sep</TD><TD class="xl72">Oct</TD><TD class="xl72">Nov</TD><TD class="xl72">Dec</TD><TD class="xl72">Jan</TD><TD class="xl72">Feb</TD><TD class="xl72">Mar</TD><TD class="xl73">Apr</TD><TD class="xl70">Total</TD><TD class="xl71">May</TD><TD class="xl72">Jun</TD><TD class="xl72">Jul</TD><TD class="xl72">Aug</TD><TD class="xl72">Sep</TD><TD class="xl72">Oct</TD><TD class="xl72">Nov</TD><TD class="xl72">Dec</TD><TD class="xl72">Jan</TD><TD class="xl72">Feb</TD><TD class="xl72">Mar</TD><TD class="xl73">Apr</TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 1</TD><TD align="right" class="xl76">10</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">10</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 2</TD><TD align="right" class="xl76">10</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">10</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD><TD align="right" class="xl76">1</TD><TD class="xl76"> </TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 3</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 4</TD><TD align="right" class="xl76">22</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">22</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 5</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 6</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">24</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD></TR><TR><TD class="xl74" height="17">Americas</TD><TD class="xl75">Manager 7</TD><TD align="right" class="xl76">22</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">22</TD><TD align="right" class="xl76">2</TD><TD class="xl76"> </TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD><TD align="right" class="xl76">2</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Load-Multiple-Header-data-in-qlik/m-p/26368#M787412 mail2bsk 2020-11-25T16:16:04Z Re: Load Multiple Header data in qlik https://community.qlik.com/t5/QlikView/Load-Multiple-Header-data-in-qlik/m-p/26369#M787413 <HTML><HEAD></HEAD><BODY><P>Maybe look this <A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P></BODY></HTML> Wed, 14 Feb 2018 21:04:37 GMT https://community.qlik.com/t5/QlikView/Load-Multiple-Header-data-in-qlik/m-p/26369#M787413 settu_periasamy 2018-02-14T21:04:37Z