Discussion Board for collaboration on QlikView Scripting.
there is the possibility to use the outer left join in loading script ?
Go to Solution.
I think here you need the WHERE NOT EXISTS() with RIGHT JOIN
WHERE NOT EXISTS(id);
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
To use the left join
Load Key,fields from X;
Load Key, Fields2 from Y;
I think left and outer left is same
Extracting existing lines on table 1 and not existing in table2 ==> you need left join
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:
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
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