Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Load worksheets with similar names

Hello, all.

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.

Thanks!

1 Reply
lakshmikandh
Valued Contributor II

Re: Load worksheets with similar names