outer left join

[souadouert]

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

[souadouert]

[YoussefBelloum · Accepted solution]

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]

thank you youssef

[Anonymous]

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]

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?