topic Loading Two columns as header from Excel in QlikView https://community.qlik.com/t5/QlikView/Loading-Two-columns-as-header-from-Excel/m-p/400003#M148842 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Can any one please help me my requirement.</P><P></P><P>I have the Data like below in Excel in one sheet</P><P></P><P>Target_Date&nbsp;&nbsp;&nbsp; Ordered_Date&nbsp;&nbsp; Completion_Date</P><P></P><P>12/12/2012&nbsp;&nbsp;&nbsp;&nbsp; 05\12\2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08\12\2012</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name&nbsp; Location</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John&nbsp;&nbsp;&nbsp;&nbsp; NAM</P><P>2&nbsp;&nbsp;&nbsp; chris&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; APAC</P><P></P><P></P><P>while loading this exel sheet to qlikview i have to take first column and third column as headers .</P><P></P><P>I have to report the table like this below&nbsp; on the main screen</P><P></P><P>ID NAME&nbsp; Location Target_Date&nbsp; Ordered_Date Completion_Date</P></BODY></HTML> Wed, 12 Sep 2012 11:42:50 GMT pavanthota 2012-09-12T11:42:50Z Loading Two columns as header from Excel https://community.qlik.com/t5/QlikView/Loading-Two-columns-as-header-from-Excel/m-p/400003#M148842 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Can any one please help me my requirement.</P><P></P><P>I have the Data like below in Excel in one sheet</P><P></P><P>Target_Date&nbsp;&nbsp;&nbsp; Ordered_Date&nbsp;&nbsp; Completion_Date</P><P></P><P>12/12/2012&nbsp;&nbsp;&nbsp;&nbsp; 05\12\2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08\12\2012</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name&nbsp; Location</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John&nbsp;&nbsp;&nbsp;&nbsp; NAM</P><P>2&nbsp;&nbsp;&nbsp; chris&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; APAC</P><P></P><P></P><P>while loading this exel sheet to qlikview i have to take first column and third column as headers .</P><P></P><P>I have to report the table like this below&nbsp; on the main screen</P><P></P><P>ID NAME&nbsp; Location Target_Date&nbsp; Ordered_Date Completion_Date</P></BODY></HTML> Wed, 12 Sep 2012 11:42:50 GMT https://community.qlik.com/t5/QlikView/Loading-Two-columns-as-header-from-Excel/m-p/400003#M148842 pavanthota 2012-09-12T11:42:50Z Re: Loading Two columns as header from Excel https://community.qlik.com/t5/QlikView/Loading-Two-columns-as-header-from-Excel/m-p/400004#M148843 <HTML><HEAD></HEAD><BODY><P>It's hard to see from your description of the Excel layout what it really looks like. Can you post a sample of the excel data?</P></BODY></HTML> Wed, 12 Sep 2012 17:59:22 GMT https://community.qlik.com/t5/QlikView/Loading-Two-columns-as-header-from-Excel/m-p/400004#M148843 Jason_Michaelides 2012-09-12T17:59:22Z