Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
pavanthota
Creator

Loading Two columns as header from Excel

Hi ,

Can any one please help me my requirement.

I have the Data like below in Excel in one sheet

Target_Date    Ordered_Date   Completion_Date

12/12/2012     05\12\2012        08\12\2012

ID      Name  Location

1      John     NAM

2    chris      APAC

while loading this exel sheet to qlikview i have to take first column and third column as headers .

I have to report the table like this below  on the main screen

ID NAME  Location Target_Date  Ordered_Date Completion_Date

1 Reply
Jason_Michaelides
Luminary Alumni

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?