I have two columns, each has a list of customer names. I need to find out what names are in both columns. Any thoughts on how I can do that? or how I can only keep the customer name that are not in both columns? Thanks
You can use the Intersect transform.
kim.transform (1.9 KB)