Find unmatched records between 2 datasets
Posted on 2015-01-27
Am having a 'memory is full' moment.
I have 2 datasets with the exact same columns and data format, but one contains more records than the other. I am attempting to identify the records that are present in one but not the other.
My data is an output from Alteryx, but have brought it into Access to attempt to resolve this.
There are 32 columns in both tables. First one is Compare1 with 26364 records, the second is Compare 2 with 26260 records.
There is not a primary key, nor any unique set of columns to do a comparison on.
Your assistance is greatly appreciated.