WHERE NOT EXISTS in Graphical Calculation View

[former_member216748]

Hi,

I have 2 tables like example below

Table1 as

Emp_No,          Emp_Name

101                   John

102                   Mick

103                   Jack

Table2 as

Emp_No,          Emp_Country

102                   Norway

My expected output is like

Emp_No,          Emp_Name

101                   John

103                   Jack

This output we can get through the below SQL

Select Emp_no, Emp_Name from Table1 as T1 where not exists (select Emp_No from Table2 as T2 where T2.Emp_No = T1.Emp_No);

Can you please suggest how to model the above logic in Graphical Calculation View.

Regards,

Kris

[uladzislau_pralat]

Hi Kris,

first union two tables, then aggregate grouping by Emp_No, Emp_Name, Emp_Country and finally project selecting Emp_Country equal space.

Regards, Uladzislau