LEFT OUTER JOIN SQL in Qlik

Claudiu_Anghelescu — Sat, 16 Nov 2024 18:47:27 GMT

How to handle LEFT OUTER JOIN with the following ON Clause?

TABLE_A

....

LEFT OUTER JOIN TABLE_B ON TABLE_B.[Item] = TABLE_A.[Item] and (TABLE_B.[Region Code] = 0 or TABLE_B.[Country Code] = TABLE_A.[Country Code])

Re: LEFT OUTER JOIN SQL in Qlik

Arthur_Fong — Tue, 14 Apr 2020 07:20:47 GMT

noconcatenate
TABLE_B:
LOAD <Columns in table B>,
Table_B.Item as Item,
Table_B.Country_Code as Country_Code
RESIDENT tempTABLE_B
where [Region_Code]=0;

drop table tempTABLE_B;

left join(TABLE_B)
load
<Columns in table A>,
Table_A.Item as Item,
Table_A.Country_Code as Country_Code
resident
TABLE_A

The idea here is to switch sql <on> clause to columns with the same name in both table,
ideally the key to join both tables.

topic Re: LEFT OUTER JOIN SQL in Qlik in QlikView

LEFT OUTER JOIN SQL in Qlik

Re: LEFT OUTER JOIN SQL in Qlik