topic Re: How to load multiple XL files into qlikview? in QlikView

How to load multiple XL files into qlikview?

Thu, 28 May 2015 17:09:16 GMT

Hi,

I create qv applcation with xl file.in qlikview is it possible to load multiple xl files in qlikview.I want to load 2 or more xl files at a time in qlikview.pls tell me out how to load multiple files into qlikview.

Thankyou,

Regards

madhu

Re: How to load multiple XL files into qlikview?

ramoncova06 — Thu, 28 May 2015 17:10:45 GMT

what is the name of the files ?

you can set several load statements for as many excel files you want

Re: How to load multiple XL files into qlikview?

Anonymous — Thu, 28 May 2015 17:18:30 GMT

Madhu

The simplest way is to have a seperate load statement for each file you wish to load.

You will need to decide whether your wish each file to go into a seperate table, or your may wish to concatenate or join them. That all depends on the files and your needs.

Re: How to load multiple XL files into qlikview?

Thu, 28 May 2015 17:18:53 GMT

thankyou ramon covarrubias, file names1. Orders file,2.new orders file.3.product .file. can you explain with example pls

regards

madhu

Re: How to load multiple XL files into qlikview?

ramoncova06 — Thu, 28 May 2015 17:24:07 GMT

this is how you can load files that have different fields

data:

LOAD ReportDate,

CustomerID,

[Sub-Region]

FROM

community\data.xls

(biff, embedded labels, table is Sheet1$);

158716:

LOAD inventorydate,

cost1,

units

FROM

community\158716.xlsx

(ooxml, embedded labels, table is Sheet1);

this is how you can load files that share the same format but they have a date to difference them, in this example the name of the files are data 1.xls, data 2.xls, etc ..

data:

LOAD ReportDate,

CustomerID,

[Sub-Region]

FROM

community\data *.xls

(biff, embedded labels, table is Sheet1$);

Re: How to load multiple XL files into qlikview?

Qrishna — Thu, 28 May 2015 17:43:46 GMT

See the thread https://community.qlik.com/thread/105143