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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.