How to load multiple XL files into qlikview?

[#1]

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

[ramoncova06]

what is the name of the files ?

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

[Anonymous]

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.

[#4]

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

regards

madhu

[ramoncova06]

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$);

[Qrishna]

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