Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello dear Qlik Sense community!
I have loaded in two tables (and done some aggregations with both of them) and now I would like to outer join these two tables.
My first table:
RECEIVABLES3:
NoConcatenate Load
DIMENSION04,
AMT
Resident RECEIVABLES2;
DROP table RECEIVABLES2;
Second table:
BROKER_D:
Noconcatenate Load
DIMENSION04,
AMT_br
resident BROKER_C;
drop table BROKER_C;
I would like to join these tables. As a result I would like to have one table, which has three columns: DIMENSION04, AMT and AMT_br. AMT and AMT_br are columns with numerical values, DIMENSION04 is an unique characteristic. Some DIMENSION04 values could be present in both tables. In final table I want to have all DIMENSION04 values and corresponding AMT and AMT_br values.
For joining I tried this:
Outer join (RECEIVABLES3) LOAD * Resident BROKER_C;
However, it doesn't work as I expect. As a result I don't get one table, but three tables, out of which one is synthetic table.
What am I missing?
All the best
Maasool
You need to drop the BROKER_D table after joining.
DROP Table BROKER_D ;
You need to drop the BROKER_D table after joining.
DROP Table BROKER_D ;
Thanks for quick reply! It worked 🙂