Solved: Where not exist or left outer join - Qlik Community

danimelo1 · ‎2017-11-30

Hello all,

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

employees:

Load * Inline [

ID

1

2

3

4

5

];

actives:

Load * Inline [

ID

1

2

3

];

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 · ‎2017-11-30

Try

Actives:

Load * Inline [

ID

1

2

3

];

NoConcatenate

FinalTable:

Load ID as EmpID

where Not Exists(ID,ID);

Load * Inline [

ID

1

2

3

4

5

];

View solution in original post

shraddha_g · ‎2017-11-30

Try

Actives:

Load * Inline [

ID

1

2

3

];

NoConcatenate

FinalTable:

Load ID as EmpID

where Not Exists(ID,ID);

Load * Inline [

ID

1

2

3

4

5

];

PrashantSangle · ‎2017-11-30

Try below

actives:

Load * Inline [

ID

1

2

3

];

employees:

Load * Inline [

ID1

1

2

3

4

5

] where not exists(ID,ID1);

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anil_Babu_Samineni · ‎2017-11-30

May be this?

Load * Inline [

ID

1

2

3

];

employees:

Load ID as ID1 Inline [

ID

1

2

3

4

5

] where not exists(ID,ID1);

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful