How to identify duplicates? Unique tool shows false duplicates - weird.

[MS0121]

Hello,

I am trying to identify certain duplicates using certain fields within a data set. I have attached an example below: 

Task(1) Identify all of the duplicated invoices numbers only

Task (2) Identify all duplicated invoice numbers and invoice amounts only

Data:

Record	Invoice Number	PO Number	Supplier Name	Invoice Amount
1	212121222	34	Nike	£1000
2	342451451	12	Adidas	£709
3	212121222	57	Nike	£5000
4	212121222	10	Nike	£1000

Task 1 results should show records 1, 3 & 4 as the invoice numbers are identical

Task 2 results should show record 1 & 4 as the invoice amount and invoice numbers are identical. 

I have used the unique tool but it should false duplicates when clicking (d).

Any help would be appreciated, I am new to using Alteryx Designer. 

Thank you. 

[atcodedog05]

Hi @MS0121 

Here is how you can do it.

Workflow:

Hope this helps : )

[binuacs]

@MS0121 another option using summarize tool and join tool

[JaeLim]

Hi @MS0121,

Here is one way to do it:

Alternatively, you can speed this up by using the "Only Unique" marco tool in the near future, downloadable here
http://www.chaosreignswithin.com/2014/08/only-unique-macro.html

[MS0121]

Thank you all. 

[ddiesel]

Hi @MS0121!

Will you mark which solution(s) were most helpful?