topic How to pull missing records in QlikView https://community.qlik.com/t5/QlikView/How-to-pull-missing-records/m-p/1199869#M879884 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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</P><P></P><P>Thanks,<BR />Vidya</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z How to pull missing records https://community.qlik.com/t5/QlikView/How-to-pull-missing-records/m-p/1199869#M879884 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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</P><P></P><P>Thanks,<BR />Vidya</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-pull-missing-records/m-p/1199869#M879884 2020-11-25T16:16:04Z Re: How to pull missing records https://community.qlik.com/t5/QlikView/How-to-pull-missing-records/m-p/1199870#M879885 <HTML><HEAD></HEAD><BODY><P>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:</P><P></P><P>Employee:</P><P>LOAD EmpID, EmpID as EmpIDCheck, ...other fields.... FROM Employee</P><P></P><P style="font-size: 13.3333px;">Utilization_Missing:</P><P>LOAD EmpID, ...other fields... FROM Utilization <STRONG>WHERE Not Exists(EmpIDCheck, EmpID)</STRONG>;</P><P></P><P>DROP FIELD <SPAN style="font-size: 13.3333px;">EmpIDCheck;</SPAN></P></BODY></HTML> Tue, 18 Oct 2016 05:39:01 GMT https://community.qlik.com/t5/QlikView/How-to-pull-missing-records/m-p/1199870#M879885 Gysbert_Wassenaar 2016-10-18T05:39:01Z