AnsweredAssumed Answered

Finding Non Matching Records

Question asked by simonkramer on Jan 5, 2015
Latest reply on Jan 6, 2015 by simonkramer



I'm importing a worked hours dataset from Excel every 30 minutes and need to find new Employee and Job records within the dataset.  The Employees and Jobs also have unique ID's which I suppose should make it easier.


I thought I could somehow compare the newly uploaded data to the Employee table using the unique ID and find those records in the new data that don't have a corresponding record in the Employee table?  I also thought this would be easy ... I tried a 'not equal' join between the ID field in the Employee table and new data Employee ID field and expected a list of data for Employees not in Employee table?


Any thoughts?  I'd be very grateful?


Thanks in advance,