Merging Files but Removing Duplicates and Favoring One Source File Over the Second

[Chad_Cox]

I’ve pulled data from two unique sources (Source File: UGA and DOAS).  Now, what I want is everything from DOAS and then ONLY those records from UGA that are not found in the DOAS file.  I need suggestions on how to accomplish this.  Within the data the following fields should match between both source files: Contract Name, Contract Number, Contract Type.

Example:

Line 21 should stay and line 22 should not end up in the final dataset.  However, line 23 should be in the final dataset because it is not found in the DOAS source file.

Lines 65 thorough 73 are not found in the DOAS source file so they should be in the final data set.

I've attached the data as it appears at this stage of my workflow.  I've also attached my workflow file.  I'm looking for a solution to add on to the join function.

[TimN]

I think you can sort by Contract Number Ascending and Source File descending and then follow the sort tool with a unique tool with Contract Number as the selected unique value.  This assumes that Contract Number is the unique ID.

[TimN · Accepted solution]

Sorry, sort Source file as ascending as well.  That should do it