Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bwisealiahmad
Not applicable

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

Accepted Solutions
arulsettu
Not applicable

Re: Load all Excel Files from folderin Qlik Sense

11 Replies
arulsettu
Not applicable

Re: Load all Excel Files from folderin Qlik Sense

arulsettu
Not applicable

Re: Load all Excel Files from folderin Qlik Sense

bwisealiahmad
Not applicable

Re: Load all Excel Files from folderin Qlik Sense

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

bwisealiahmad
Not applicable

Re: Load all Excel Files from folderin Qlik Sense

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

shraddha_g
Not applicable

Re: Load all Excel Files from folderin Qlik Sense

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
Not applicable

Re: Load all Excel Files from folderin Qlik Sense

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

bwisealiahmad
Not applicable

Re: Load all Excel Files from folderin Qlik Sense

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
Not applicable

Re: Load all Excel Files from folderin Qlik Sense

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
Not applicable

Re: Load all Excel Files from folderin Qlik Sense

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