Discussion Board for collaboration related to QlikView App Development.
How to handle LEFT OUTER JOIN with the following ON Clause?
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])
noconcatenateTABLE_B:LOAD <Columns in table B>,Table_B.Item as Item,Table_B.Country_Code as Country_CodeRESIDENT tempTABLE_Bwhere [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_CoderesidentTABLE_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.
View solution in original post