outer left join

[souadouert]

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

[Or]

Load Field1, Field2

From Table1;

Left Join

Load Field2, FIeld3

From Table2;

Note that if your tables aren't loaded in succession, you can use:

Table1:

Load Field1, Field2

From Table1;

...

(More loads here)

...

Left Join(Table1)

Load Field2, FIeld3

From Table2;

[souadouert]

hELLO,
OUTER LEFT JOIN , not join  , i want to extract line exsitin table 1 and not exist in table 2

[sushil353]

To use the left join

Table1:

Load Key,fields from X;

left join(Table1)

Load Key, Fields2 from Y;

I think left and outer left is same

HTH

Sushil

[YoussefBelloum]

Extracting existing lines on table 1 and not existing in table2 ==> you need left join

[Or]

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:

https://community.qlik.com/docs/DOC-9083

[maxgro]

you can use a left join

Join ‒ QlikView

IMOHO

LEFT JOIN and LEFT OUTER JOIN are the same

[vvvvvvizard]

Qlikview has inner join , left join , right join , join (which is default outer )  only

[souadouert]

Hello youssef ,

left join all lines existing  in table 1 with the intersection  (table2) if is possible , i need the outer left

[YoussefBelloum]

Souad, I think you should attach 2 tables example here