Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mdmukramali
Valued Contributor II

Loading all excel files from a folder

Dears,

I'm trying to load all the excel files from a folder into Qlik Sense.

Weekly wise excel files are add to that folder so i want to load them.

Thanks,

Mukram.

1 Solution

Accepted Solutions

Re: Loading all excel files from a folder

You could use a wild card in your load statement, as in something like :

Load  ...... from ....\*.xls* ...............

5 Replies

Re: Loading all excel files from a folder

You could use a wild card in your load statement, as in something like :

Load  ...... from ....\*.xls* ...............

mdmukramali
Valued Contributor II

Re: Loading all excel files from a folder

Hello Bill Markham,

i tried it already it's loading only one file from the folder.

i'm looking something like for loop method to load all the excel files

Re: Loading all excel files from a folder

Strange, it always works for me.  Could you share your load script ?

Not applicable

Re: Loading all excel files from a folder

you could use 'Load * From [path\data*.txt] (ansi, txt, delimiter is '\t', embedded labels);'

mdmukramali
Valued Contributor II

Re: Loading all excel files from a folder

Dear Bill Markham,

it's working.

actually the sheet-name in some excel files are sheet1 and in some files it's salesdata and

other than this some of the excel files format is different that why it's not reloading all the files.

LOAD

  *

FROM [lib://Excel Files Data (Mukram/*.xlsx]

(ooxml, embedded labels, table is Sheet1);

Working....

Thanks,

Mukram.