Skip to main content
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.