Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple file load wither inner join

Hello,

I have tried to load from multiple files 3 tables, which I wanted to concatenate. So I've used the Load From [Path\*.xlsx] (all my files ae xlsx and in the same folder).

Rapport1:

LOAD *

FROM [pahtfield*.xlsx](ooxml, embedded labels, table is [Rapport 1]);

inner join (Rapport1)   

LOAD *

FROM

[pathfield\*.xlsx]

(ooxml, embedded labels, table is [Rapport 2]);

But I had no data loaded

Any one can help my with this?

Thank you

10 Replies
swuehl
MVP
MVP

I thought I've done that already with my first post...

//Assuming that all tables [Rapport 1] have same structure, so LOAD will autoconcatenate

//Assuming that all tables [Rapport 2] have same structure, so second LOAD will autoconcatenate

//Assuming that Rapport1 and Rapport2 have some, but not all common fields, and some matching key field values

Rapport1:

LOAD *

FROM [pahtfield*.xlsx](ooxml, embedded labels, table is [Rapport 1]);

Rapport2:

LOAD *

FROM

[pathfield\*.xlsx]

(ooxml, embedded labels, table is [Rapport 2]);

INNER JOIN (Rapport1) LOAD * RESIDENT Rapport2;

DROP TABLE Rapport2;