Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to load Multiple file into a qlikview?

Hi All,

I have 65 files in excel format, all files name are different but field name are same. How can I load those files into a qlikview? Please help..

Thanking You.

Regards

Anup Kumar Patra

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

If all the files are kept in same directory, then try this

Load * From C:\Path\*.xlsx

View solution in original post

5 Replies
anbu1984
Master III
Master III

If all the files are kept in same directory, then try this

Load * From C:\Path\*.xlsx

PrashantSangle

Hi,

Try like

load *

from filepath/*.qvd

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
MarcoWedel

Hi,

use wildcards in the filename

table1:

LOAD *

FROM path\*.xlsx

(ooxml, embedded labels, table is sheet1);

hope this helps

regards

Marco

its_anandrjs

Hi,

Then try this load script this works for only xlsx files and this loads all excel file from existing source folder and add the FileName() function for identify file name.

LET Path = 'D:\';

Load *,

FileName() as FileFlag

From

[Path\* .xlsx]

Regards

Anand

Not applicable
Author

Thanks to all. All sugeations are working fine. But here I have some question suppose in my Excel list one or two excel are modified then that time I have to reload all the file unnecessarily, is there any solution for that?

Thank You all of you for the reply.

Regards

Anup Kumar Patra