Unique Tool

[JingYih_Herbalife]

Hi,

I would like to separate the PR numbers that are duplicates to perform further analysis. 

In the example below, I would like to view all the PR numbers 512411 & 512412 together. 

Record number	PR Number	PO Number
1	512410	112320
2	512411	112321
3	512411	112321
4	512411	112321
5	512412	112322
6	512412	112322

I tried using the unique tool, under the unique tool the duplicate result only gives me record number 3, 4 and 6. It considers record number 2 & 5 as unique. 

Thanks and in advance.

[JosephSerpis · Accepted solution]

Hi @JingYih_Herbalife that is expected behaviour from the unique tool you would need to use a join tool with the data from D anchor on the duplicates to join back onto your original data to filter to find the true unique records which have no duplicates at all. I mocked up a example using your data.

[DataNath]

Hey @JingYih_Herbalife, the Unique tool works by separating out the first occurrence of a combination of field(s) you have selected as unique, and then any subsequent occurrences are classed as duplicates of that. Therefore, for records 2 & 5, these are the first occurrence of PR number 512411 and 512412 respectively and are classed as unique. The records that follow with the same PR number are considered duplicates, in your case 3, 4 & 6. If you want to look at these PR numbers when there is more than 1, I’d create a new branch where you use a Summarize to perform a count by PR number, join this back using PR number as the condition and then filter for Count > 1.