Please advise me on simple matter. I use Qlik view. I'd like to load data from all spreadsheets of Excel files in the folder. I do not know particularly how much sheets are there in every file. How do I need to write the circle to do this? Thanks a lot!
LOAD * FROM [\\XXX\YYY\*.xls*] (ooxml, embedded labels)
