how to load data from multiple excel files

Thu, 25 Dec 2014 08:51:07 GMT

can you pleasehelp me in this problem

i am trying to load data from many excel files .All these file names are starting with the word (data).

There is only one sheet in all files with same format .The diffrent is three rows at the begining contain the tilte and other detials of the file but have same format . i need these rows to

differentiation

لتفاضل, تمييز, مفاضلة, تفريق

how can i load these date

Re: how to load data from multiple excel files

Gysbert_Wassenaar — Thu, 25 Dec 2014 09:52:15 GMT

You can load from multiple excel files using the wildcard character *.

If all sheets are the same except the first three rows, then you can skip those three rows by setting the header to 3 lines.

You can create a new field using the FileName() function so you can keep track of which record came from which file.

MyExcelData:

LOAD *, FileName() as SourceFile

FROM

(ooxml, embedded labels, header is 3 lines,table is Sheet1);

If you also need the information from the first three lines you probably need to load that data in a separate table: Since you did not post an excel file I can't help you with that part.

topic how to load data from multiple excel files in QlikView

how to load data from multiple excel files

Re: how to load data from multiple excel files