Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;