Load data from multiple excel files

[#1]

Hi ,

Is it possible to load data from multiple excel files ... if they are are stored in folders

for example 

Foldername: Orders_2011 

Subfolders: Orders_Jan.......Upto.........Orders_Dec

Files in Orders_Jan are Stored like

Orders_01012011

.

.

.

Orders_01302011.

If i have to load each file individually its a big manual Process . Appreciate any help on this

Thanks

[#2]

hi Monica,

u can load the files in same folders by putting Order *.xls in ur from statement if u want to pick all excel file that are starting with name Order.

or if u want to fetch all teh fiels in the folder Order_2011 thn u need to write following in from statement:

from

[jagannalla]

Try this,

Concatenate

LOAD *

FROM

D:\Orders_2011\Orders_Jan.......Upto.........Orders_Dec\*.txt

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Concatenate helps you to append the missing fields of next loading files.

[Siva_Sankar]

Monica, Refer the link http://community.qlik.com/message/220535#220535 and  http://community.qlik.com/message/223844#223844.  Hope it helps.  Regards. Siva Sankar

[vincent_ardiet]

Hi,

Have a look to this one too http://community.qlik.com/message/109529#109529.

Combining the examples above and this one you will be able to load your files.

Regards,

Vincent