Concatenate several files

[alec1982]

hi guys,

I have several xlsx files with the same start of a name they all start with DR_

They all have four identical columns names and i am in a need to load one table of the four identical columns from all the files..

What would be the best approach to concatenate?

Thxs,

Alec

[its_anandrjs]

Keep all the files in same folder location and as you say they have same column name then concatenate them with load statement like

LOAD

*,

Filename( ) as Filename //Add this flag to get the details of the filename

FROM

[C:\YourLocation\DR_*.xlsx]

(ooxml, embedded labels, table is Sheet1);

Change Your location as your folder location

Note:- The files have same column name and in same sheet1 and in single folder location this condition are must required.

[PradeepReddy]

try this ....

place all files in same folder..

Tab:

LOAD Field1,

     Field2,

     Field3,

     Field4

FROM

DR_*.xlsx

(ooxml, embedded labels, table is Sheet1);

[rogerioqv]

Hello,

See if it works:

LOAD

   COLUMN1,

   COLUMN2,

   column3,

   column4

FROM

[Dr_ *. Xlsx

(OOXML, embedded labels, table is Sheet1);

[alec1982]

hi guys,

My files are failing to load due to having different sheet names.. any solution?

Thxs for all your help!

[maxgro]

loop on excel files

and for every file

read here

Re: Pulling multiple excel sheets into QV when all headings are the same

to load the first sheet without knowing the name

[its_anandrjs · Accepted solution]

Then try with this

LOAD

*,

Filename( ) as Filename //Add this flag to get the details of the filename

FROM

[C:\YourLocation\DR_*.xlsx]

(ooxml, embedded labels, table is [$(*)]);

[alec1982]

Thxs! This work for me!