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)
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:
