Compare duplicated fields

I have around 1.5k records which are duplicated on [name] [Address] and [Post Code] - when i used the unique tool it only shows the one duplicated record. I need to see both records that are duplicated next to each other so i can compare.

What is the best way to do this?

Thanks,

Kerry

Data Investigation

Accepted answers

JosephSerpis

Hi @KCAgentProvocateur the unique tool has two outputs the Unique output which would leave one values then the duplicated fields will come out of the second output. To View to together which I think you mean side by side you would need to use a join from the Unique output and the duplicate output of the Unique tool.

All comments

JosephSerpis

Hi @KCAgentProvocateur an easy way to compare against those 3 records and use the Unique tool is by using the formula tool to create a new string field which is a concatenation of those fields e.g. Name + Address + Postcode then use the unique tool on that new field.

KCAgentProvocateur

Hey,

But i was under the impression that the unique tool took out the duplicated values - leaving one value as unique and one as duplicated?

So i wouldn't be able to view them next to each other?

Thanks,

Kerry

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703