Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bwisealiahmad
Partner - Specialist
Partner - Specialist

Load all Excel Files from folderin Qlik Sense

Hi,

I was wondering if someone could share an example of loading all excel files in a folder done in Qlik Sense without putting it into legacy mode? I've seen some QV examples using an ODBC connector style of doing it, but wanted to see if anyone has an easier / better way to do it around.


Best,

Ali A

1 Solution
12 Replies
bwisealiahmad
Partner - Specialist
Partner - Specialist
Author

How would you adapt this one to work with Qlik Sense?

bwisealiahmad
Partner - Specialist
Partner - Specialist
Author

I haven't seen this one, but thinking this one might work if i change it to have LIBs instead.

shraddha_g
Partner - Master III
Partner - Master III

Same script that is used ion Qlikview will work in Qliksense with change in path..

Instead of absolute path, use LIB statement.

for that you will first have to create data connection to that folder and then use [LIB://Connection name/filename]

You can modify it according to your script in qlikview

arulsettu
Master III
Master III

try to implement the same or you can use 1st option

bwisealiahmad
Partner - Specialist
Partner - Specialist
Author

Especially this part:

"

//In order to get the file information from SQLtables command making use of the ODBC connection format

ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];


"

bwisealiahmad
Partner - Specialist
Partner - Specialist
Author

Ok.

And this part:

//In order to get the file information from SQLtables command making use of the ODBC connection format

ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];


?

arulsettu
Master III
Master III

FOR EACH file in FileList('Lib\\:');