there is the possibility to use the outer left join in loading script ?
Load Field1, Field2
Load Field2, FIeld3
Note that if your tables aren't loaded in succession, you can use:
(More loads here)
hELLO,OUTER LEFT JOIN , not join , i want to extract line exsitin table 1 and not exist in table 2
Extracting existing lines on table 1 and not existing in table2 ==> you need left join
Hello youssef ,
left join all lines existing in table 1 with the intersection (table2) if is possible , i need the outer left
Souad, I think you should attach 2 tables example here
I think here you need the WHERE NOT EXISTS() with RIGHT JOIN
WHERE NOT EXISTS(id);
thank you youssef
What if one id not existing in table2 does exist more than one time in table1?
can you try this once...
Load * Inline
Load *,id as id1 Resident T2;
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
That's not an outer left join. In SQL, that would be a MINUS operator.
In Qlik, you handle this with NOT EXISTS - see the following for examples:
To use the left join
Load Key,fields from X;
Load Key, Fields2 from Y;
I think left and outer left is same
you can use a left join
Join ‒ QlikView
LEFT JOIN and LEFT OUTER JOIN are the same
Qlikview has inner join , left join , right join , join (which is default outer ) only
Retrieving data ...