topic Re: How to load Multiple file into a qlikview? in QlikView

How to load Multiple file into a qlikview?

Mon, 12 Jan 2015 07:10:58 GMT

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

Re: How to load Multiple file into a qlikview?

anbu1984 — Mon, 12 Jan 2015 07:13:33 GMT

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?

PrashantSangle — Mon, 12 Jan 2015 07:13:39 GMT

Hi,

Try like

load *

from filepath/*.qvd

Regards,

Re: How to load Multiple file into a qlikview?

MarcoWedel — Mon, 12 Jan 2015 07:15:18 GMT

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?

its_anandrjs — Mon, 12 Jan 2015 07:15:25 GMT

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

Re: How to load Multiple file into a qlikview?

Mon, 12 Jan 2015 08:26:35 GMT

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