Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
maasool
Contributor III
Contributor III

Joining two already loaded tables

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

 

Labels (1)
1 Solution

Accepted Solutions
jonathandienst
Partner
Partner

You need to drop the BROKER_D table after joining.

DROP Table BROKER_D ;

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst
Partner
Partner

You need to drop the BROKER_D table after joining.

DROP Table BROKER_D ;

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
maasool
Contributor III
Contributor III
Author

Thanks for quick reply! It worked 🙂