topic Re: Generate table from excel in QlikView https://community.qlik.com/t5/QlikView/Generate-table-from-excel/m-p/118937#M18336 <HTML><HEAD></HEAD><BODY><P>Maybe try</P><P></P><P><STRONG>First 2</STRONG></P><P>Load </P><P>Customer,</P><P>CustomerBrand,</P><P>AllocatedInstruments,</P><P>Date</P><P>From.....ABC.xls</P></BODY></HTML> Fri, 06 Jul 2018 18:04:25 GMT MK9885 2018-07-06T18:04:25Z Generate table from excel https://community.qlik.com/t5/QlikView/Generate-table-from-excel/m-p/118936#M18335 <HTML><HEAD></HEAD><BODY><P>There's a way to generate the table below from the 2 rows on the first excel ?</P><P>Which function i can use?</P><P>Thank you!!</P><P></P><P><IMG alt="instruments reportsss.PNG" class="jive-image image-1" src="/legacyfs/online/207222_instruments reportsss.PNG" style="height: 365px; width: 620px;" /></P></BODY></HTML> Fri, 06 Jul 2018 14:59:34 GMT https://community.qlik.com/t5/QlikView/Generate-table-from-excel/m-p/118936#M18335 qlikviewaf 2018-07-06T14:59:34Z Re: Generate table from excel https://community.qlik.com/t5/QlikView/Generate-table-from-excel/m-p/118937#M18336 <HTML><HEAD></HEAD><BODY><P>Maybe try</P><P></P><P><STRONG>First 2</STRONG></P><P>Load </P><P>Customer,</P><P>CustomerBrand,</P><P>AllocatedInstruments,</P><P>Date</P><P>From.....ABC.xls</P></BODY></HTML> Fri, 06 Jul 2018 18:04:25 GMT https://community.qlik.com/t5/QlikView/Generate-table-from-excel/m-p/118937#M18336 MK9885 2018-07-06T18:04:25Z Re: Generate table from excel https://community.qlik.com/t5/QlikView/Generate-table-from-excel/m-p/118938#M18337 <HTML><HEAD></HEAD><BODY><P>Hi Antonio,</P><P></P><P>Try with this example:</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207252_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Fri, 06 Jul 2018 20:42:34 GMT https://community.qlik.com/t5/QlikView/Generate-table-from-excel/m-p/118938#M18337 joseph_morales 2018-07-06T20:42:34Z