Concatenate table and left join

[MK25]

Hi,

I'm struggling with creation one big table. I have 4 tables (A, B, C and D). Tables A and B mast be concatenaded. Tables C and D- also must be concatenated and then i would like left join bolth concatenaded tables. example: (A concatenate B) Left Join (C Concatenate D).

Any ideas? All help in greatly appreciated.

A:
LOAD
ID,
Value,
Item
FROM [lib://Testno:DataFiles/Uvoz Qlik.xlsx]
(ooxml, embedded labels, table is P2021);

B:
LOAD
ID,
Value,
Item
FROM [lib://Testno:DataFiles/Uvoz Qlik.xlsx]
(ooxml, embedded labels, table is P2022);

C:
LOAD
ID,
Year,
Customer
FROM [lib://Testno:DataFiles/Uvoz Qlik.xlsx]
(ooxml, embedded labels, table is G2021);

D :
LOAD
ID,
Year,
Customer
FROM [lib://Testno:DataFiles/Uvoz Qlik.xlsx]
(ooxml, embedded labels, table is G2022);

[vikasmahajan]

Hi,

You can try like this :

Fact:
//A:
LOAD
ID,
Value,
Item
FROM [lib://Testno:DataFiles/Uvoz Qlik.xlsx]
(ooxml, embedded labels, table is P2021);
Concatenate
//B:
LOAD
ID,
Value,
Item
FROM [lib://Testno:DataFiles/Uvoz Qlik.xlsx]
(ooxml, embedded labels, table is P2022);
left join(Fact)
//C:
LOAD
ID,
Year,
Customer
FROM [lib://Testno:DataFiles/Uvoz Qlik.xlsx]
(ooxml, embedded labels, table is G2021);
Concatenate
//D :
LOAD
ID,
Year,
Customer
FROM [lib://Testno:DataFiles/Uvoz Qlik.xlsx]
(ooxml, embedded labels, table is G2022);

Hope this help you.

Vikas

[MK25]

Thank you, but something go wrong. When I create table (Analyze/Edit sheet/Table) I get next result:

I marked only two problematic example. Any suggestions?

[vikasmahajan]

instead of left join can u try with outer join ? like  Outer join(Fact)

Vikas

[MarcoWedel]

table1:
LOAD A
Concatenate
LOAD B

tabTemp:
LOAD C
Concatenate
LOAD D

Left Join (table1)
LOAD * Resident tabTemp;

Drop Table tabTemp;

hope this helps

Marco