topic Re: Load data from multiple excel files in QlikView

Load data from multiple excel files

Wed, 20 Jun 2012 13:00:07 GMT

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

Wed, 20 Jun 2012 13:08:58 GMT

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 — Wed, 20 Jun 2012 13:34:34 GMT

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 — Wed, 20 Jun 2012 13:40:05 GMT

vincent_ardiet — Wed, 20 Jun 2012 14:26:28 GMT

Hi,

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

Regards,

Vincent