Unique Tool

Question

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 numberPR NumberPO Number151241011232025124111123213512411112321451241111232155124121123226512412112322

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 Answer

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.