Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
Honored Contributor III

Re: How to load Multiple file into a qlikview?

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

Load * From C:\Path\*.xlsx

5 Replies
anbu1984
Honored Contributor III

Re: How to load Multiple file into a qlikview?

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

Load * From C:\Path\*.xlsx

Re: How to load Multiple file into a qlikview?

Hi,

Try like

load *

from filepath/*.qvd

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

Re: How to load Multiple file into a qlikview?

Hi,

use wildcards in the filename

table1:

LOAD *

FROM path\*.xlsx

(ooxml, embedded labels, table is sheet1);

hope this helps

regards

Marco

Re: How to load Multiple file into a qlikview?

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

Re: How to load Multiple file into a qlikview?

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