topic Re: Concatenate several files in QlikView

Concatenate several files

alec1982 — Thu, 29 May 2014 17:49:29 GMT

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

Re: Concatenate several files

its_anandrjs — Thu, 29 May 2014 17:59:45 GMT

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.

Re: Concatenate several files

PradeepReddy — Thu, 29 May 2014 18:00:33 GMT

try this ....

place all files in same folder..

Tab:

LOAD Field1,

Field2,

Field3,

Field4

FROM

DR_*.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: Concatenate several files

rogerioqv — Thu, 29 May 2014 18:00:57 GMT

Hello,

See if it works:

LOAD

COLUMN1,

COLUMN2,

column3,

column4

FROM

[Dr_ *. Xlsx

(OOXML, embedded labels, table is Sheet1);

Re: Concatenate several files

alec1982 — Thu, 29 May 2014 19:02:34 GMT

hi guys,

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

Thxs for all your help!

Re: Concatenate several files

maxgro — Thu, 29 May 2014 19:12:23 GMT

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

Re: Concatenate several files

its_anandrjs — Thu, 29 May 2014 19:14:34 GMT

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 [$(*)]);

Re: Concatenate several files

alec1982 — Thu, 29 May 2014 19:19:30 GMT

Thxs! This work for me!