how to load data from multiple excel files

[#1]

hi

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

[Gysbert_Wassenaar]

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.