topic Re: Concatenate table and left join in App Development

Concatenate table and left join

MK25 — Fri, 21 Jan 2022 07:30:53 GMT

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);

Re: Concatenate table and left join

vikasmahajan — Fri, 21 Jan 2022 08:21:21 GMT

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

Re: Concatenate table and left join

MK25 — Fri, 21 Jan 2022 11:50:41 GMT

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?

Re: Concatenate table and left join

vikasmahajan — Fri, 21 Jan 2022 11:54:50 GMT

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

Vikas

Re: Concatenate table and left join

MarcoWedel — Fri, 21 Jan 2022 14:13:29 GMT

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