Find matches in two columns

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)

1 Like