Loading all excel files from a folder

[mdmukramali]

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.

[Anonymous · Accepted solution]

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

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

[mdmukramali]

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

[Anonymous]

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

[#5]

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

[mdmukramali]

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.