Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How would you adapt this one to work with Qlik Sense?
I haven't seen this one, but thinking this one might work if i change it to have LIBs instead.
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
try to implement the same or you can use 1st option
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)];
"
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)];
?
FOR EACH file in FileList('Lib\\:');