How to pull missing records

[#1]

Hi,

I have two tables one is Employee and another is Utilization i am linking these two tables with EmpID.some EmpID are in Utilization but they are not there in the Employee table but i want to pull those which are there in the Utilization table.any solution for this

Thanks,
Vidya

[Gysbert_Wassenaar]

If you want a table with only the records from Utilization that don't have a matching EmpID in the Employee table you can use the Exists function:

Employee:

LOAD EmpID, EmpID as EmpIDCheck, ...other fields.... FROM Employee

Utilization_Missing:

LOAD EmpID, ...other fields... FROM Utilization WHERE Not Exists(EmpIDCheck, EmpID);

DROP FIELD EmpIDCheck;