Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

outer left join

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

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: outer left join

I think here you need the WHERE NOT EXISTS() with RIGHT JOIN

Table2:

LOAD *;

FROM...

right join

Table1:

LOAD *

FROM...

WHERE NOT EXISTS(id);

15 Replies
Or
Valued Contributor II

Re: outer left join

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
Contributor III

Re: outer left join

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

sushil353
Honored Contributor II

Re: outer left join

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
Esteemed Contributor

Re: outer left join

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

Or
Valued Contributor II

Re: outer 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:

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

MVP
MVP

Re: outer left join

you can use a left join

Join ‒ QlikView

IMOHO

LEFT JOIN and LEFT OUTER JOIN are the same

vvvvvvizard
Contributor III

Re: outer left join

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

souadouert
Contributor III

Re: outer left join

Hello youssef ,

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

YoussefBelloum
Esteemed Contributor

Re: outer left join

Souad, I think you should attach 2 tables example here

Community Browser