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: 
mdmukramali
Specialist III
Specialist III

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

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

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

View solution in original post

5 Replies
Anonymous
Not applicable

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

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

mdmukramali
Specialist III
Specialist III
Author

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

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

Not applicable

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

mdmukramali
Specialist III
Specialist III
Author

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.