Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
there is the possibility to use the outer left join in loading script ?
I think here you need the WHERE NOT EXISTS() with RIGHT JOIN
Table2:
LOAD *;
FROM...
right join
Table1:
LOAD *
FROM...
WHERE NOT EXISTS(id);
thank you youssef
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;
What you describing is called a left join in QlikView, no need for the
outer keyword
What if one id not existing in table2 does exist more than one time in table1?