Import data from excel file with different headings.

[Diinkant]

Hi,

Is it possible to import this type of dataset into Qlik where you don't know what month the heading is going to be.

I will always know, Column A, B, C. But I won't know the month that appears from column D to O. It is a 12 month period so all 12 months will appear but it could be where D becomes Jun and O becomes May.

Help if possible please.

Thanks

[rwunderlich]

Yes, use "Load *".  If you want to process it as a crosstable, it would be:

CrossTable(Month, Amount, 3)
LOAD *
From ...

-Rob