loading multiple sheets from all xls files in a folder

[fabricecallegar]

Hi,

I'm using Qlik Sense

I have a folder with multiple excel files.

I would like to load each xls file of the folder and for each of them, I would like to load some sheets.

I specify that I don't know the number or the name of the sheet but I know I want to load only those with a particular symbol or cod in their name.

how can I do that ?

thank you for your help

Fabrice Callegari

[fabricecallegar]

It works perfectly in qlikview with this solution : https://community.qlik.com/docs/DOC-7860.

But in Sense, I don't know use an ODBC connection with a variable...

Does anyone have a solution ?

[mjm]

Hello Fabrice,

I dont know the exact syntax but I would point you in the direction of the for....each command. This will allow you to iterate through all of the files in the chosen folder. This should work as long as the sheets in each of the excel files are named the same.

If this doesn't help then I believe also doing a wildcard load (e.g *.xls) may help.

If this does help, then please mark my response as helpful and correct.

Thanks,

[fabricecallegar · Accepted solution]

Thanks Mark but I just found the solution.

Do as explained in this page Loading Multiple Excel Sheets Dynamically along with file name and sheet name.

and disable the standard mode (http://help.qlik.com/sense/2.0/en-US/online/?_ga=1.188385836.504149128.1429862976#../Subsystems/Hub/...to allow ODBC connections without libraries.