Discussion board where members can get started with Qlik Sense.
Please help with load of Excel files and worksheets.
If you need to open multiple Excel files with similar names from folder, you can use *.
For example, test*.xlsx will open all test*. xlsx files from folder.
But what to do, if I have several worksheets in these files with similar names (like report1, report2, reportn, ...)?
I looked thru several posts but can't figure out how to do this in Qliksense.
"report*" does not work, as it does for file names.
Try Looping through worksheets,
Load excel, loop the worksheet
Trying to Loop through Sheets in a Dashboard Continually
Load multiple sheets and excel files