Finding the differences in two files

Hi, I have two sheets, customer name and customer information. Both sheets have the customer numbers in a column. How can I found out what customer numbers are not on the customer name sheet comparing the two sheets? Do I have to merge the two sheets to only find unique?

Thank you

Here a suggestion, there might be other solutions as well.
In case there are no duplicates in the files you can skip the unique transaction.

Kim FileCompare.transform (3.9 KB)

1 Like

If you have datasets A and B, each with a column of customer IDs, and you want to know what customers are in A, but B, then you can find this using the Subtract transform. Put the A dataset above the B dataset.

See also:

1 Like