Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Magalytobel
Contributor

Full Outer join two table

Please help me solve this puzzle. 

I have two different tables. I want to use one table as the lead one and the other one as the dimension table. I want all records from one table and the data from the other table if there is a match otherwise it shows blanc.

 

table 1table 2
 aa
xx 
yyyy
zz 

 

if I have 100 records in field YY table 1 after joining with table 2 with the field yy I still want the 100 records. 

 

2 Replies
marcus_sommer

In this case you need a left or right join, like:

t: load YY from Table1; left join(t) load yy as YY from Table2;

but by joins in general it depends on the existing data-structure and the data-quality if it will create duplicate records or if it may remove ones. It's not controllable with the join-statement itself - else you will need various steps in beforehand or afterwards to check and control the data.

If you couldn't ensure it with rather simply measures you shouldn't use joins else you should look for other approaches - quite common for such use-cases in Qlik is mapping.

- Marcus  

MayilVahanan

HI @Magalytobel 

You can try with left keep concept.

Table1:

load YY from Table1;

left Keep(Table1)

load YY from Table2;

In that case, final output in table viewer, you can able to see 2 table,

but its load the info in Table1 alone in Table 2. Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Community Browser