Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jleberre
New Contributor

Outer join

Hello

I would like to merge 2 tables like this:

tab1: (A+B = Primary key)

A, B

1, a

1, b

2, c

3, c

-, d

- e

tab2: (A = Primary key)

A, C

1, xx

2, yy

3, zz

result -> tab3:

A, B, C

1, a, xx

1, b, xx

2, c, yy

3, c, zz

-, d, -

-, e, -

Can I use a outer join?


tab3:

load * resident tab1 outer join load * resident tab2


I'm not sure that "-,d" and "-,e" entries of tab1 will be present in tab3


thanks!

Tags (1)
1 Solution

Accepted Solutions
micheledenardi
Valued Contributor

Re: Outer join

Of course, you can use Outer Join

2017-10-26 15_29_29-Modifica Script [C__Users_Michele.Denardi_Desktop_test2.qvw_].png

3 Replies
micheledenardi
Valued Contributor

Re: Outer join

Of course, you can use Outer Join

2017-10-26 15_29_29-Modifica Script [C__Users_Michele.Denardi_Desktop_test2.qvw_].png

antoniotiman
Honored Contributor III

Re: Outer join

May be

tab2:
Join
LOAD * Inline [
A, C
1, xx
2, yy
3, zz]
;

jleberre
New Contributor

Re: Outer join

ok, thank you!

Community Browser