topic Re: Where not exist or left outer join in QlikView

Where not exist or left outer join

danimelo1 — Thu, 30 Nov 2017 09:38:12 GMT

Hello all,

I have a table with records of employees, and other table with only active employees:

employees:

Load * Inline [

];

actives:

Load * Inline [

];

the result table I want is just keep ID 4 and 5.

How can I achieve this? I was trying with a Where not exist clause but it didn't work.

Any help?

shraddha_g — Thu, 30 Nov 2017 09:42:20 GMT

Try

Actives:

Load * Inline [

];

NoConcatenate

FinalTable:

Load ID as EmpID

where Not Exists(ID,ID);

Load * Inline [

];

PrashantSangle — Thu, 30 Nov 2017 09:42:26 GMT

Try below

actives:

Load * Inline [

];

employees:

Load * Inline [

ID1

] where not exists(ID,ID1);

Regards,

Anil_Babu_Samineni — Thu, 30 Nov 2017 09:45:00 GMT

May be this?

Load * Inline [

];

employees:

Load ID as ID1 Inline [

] where not exists(ID,ID1);