Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
spividori
Specialist
Specialist

Excel file with unknown number of columns

Hi.

I need to read an excel file with an unknown number of columns and each time it is generated the number of columns can vary. Is this possible?.

Regards.

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

Yes, by using a wildcard-load, like: load * from Source; Afterwards the loaded fields could be checked and renamed if possible. But probably you don't need this multi-step approach else your data are a crosstable which could be loaded more simply per: The Crosstable Load - Qlik Community - 1468083.

- Marcus

View solution in original post

2 Replies
marcus_sommer

Yes, by using a wildcard-load, like: load * from Source; Afterwards the loaded fields could be checked and renamed if possible. But probably you don't need this multi-step approach else your data are a crosstable which could be loaded more simply per: The Crosstable Load - Qlik Community - 1468083.

- Marcus

spividori
Specialist
Specialist
Author

It's what I needed.

Thank Marcus.