Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;