Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
It's what I needed.
Thank Marcus.