Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
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