Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

outer left join

there is the possibility to use the outer left join in loading script ?

15 Replies
souadouert
Specialist
Specialist
Author

ex.PNG

YoussefBelloum
Champion
Champion

I think here you need the WHERE NOT EXISTS() with RIGHT JOIN

Table2:

LOAD *;

FROM...

right join

Table1:

LOAD *

FROM...

WHERE NOT EXISTS(id);

souadouert
Specialist
Specialist
Author

thank you youssef

Anonymous
Not applicable

can you try this once...

T1:

Load * Inline

[

id,a

1,aa

2,bb

3,cc

4,dd

];

T2:

Load * Inline

[

id,b

1,zzz

2,yyy

5,qqq

6,ccc];

NoConcatenate

T3:

Load *,id as id1 Resident T2;

right join

Load * Resident T1

where not Exists(id1,id);

drop Field id1;

drop table T1,T2;

vvvvvvizard
Partner - Specialist
Partner - Specialist

What you describing is called a left join in QlikView, no need for the

outer keyword

MarcoWedel

What if one id not existing in table2 does exist more than one time in table1?