How to load Multiple file into a qlikview?

[#1]

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

[anbu1984 · Accepted solution]

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,

[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

[#6]

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