Unique Tool Not Identifying duplicates from two separate data inputs

jonathanl14

I'm trying to identify duplicates of Company Names after combining two months of similar data. I utilized a Union tool to combine the two months of data. I've performed these steps in excel and identified 790 duplicates; however, the Unique tool is only identifying 523. Is there a way around this? Are the two separate inputs of data treated as unique fields?

Thanks!

danilang

Hi @jonathanl14 

I think that maybe the confusion lies with the definition of "unique".  The common definition is that something is unique if there is only one of them.  The Alteryx definition of unique is "return a subset of the data such that each item appears only once in the subset". That's what the Unique tool outputs from the U anchor.  All the extras that are removed from the list are returned out the D.   

If you want to get the list of truly unique items from the data set, which is what the Only Unique macro does, you need to take the list from the U anchor and remove every item that exists in the D anchor.

Dan

TruelyUnique.yxmd