Identifying duplicates and returning a statement

Question

Hi All - I'm trying to find a way I can identify duplicates in my data and then return 'YES' in a new column. I used the Unique tool, then applied my statement BUT I need to union the data back in and when I do, the statement isn't against the duplicate row that was in the 'U' on the tool and I can't seem to find a way to get around this. I want the statement against all the duplicates but of course using the unique tool separates them out. Which is good to identify which ones are duplicates, but need to return a statement against all the rows. To help, I have attached how my data looks before, after I have tried to apply my statement, and what I want it to look after. Any help would be very much appreciated :)

Identifying duplicate data.xlsx

davidskaife · Accepted Answer

Hi @binsell

Here's one way of doing it, using the Summerize Tool:

workflow attached!

binu_acs · Accepted Answer

@binsell another way of doing it

caltang · Accepted Answer

@binsell another way of doing so:

What the tile tool does in this instance is that it finds unique values (as per setting) and gives it a record ID for each time it appears. So it groups them by unique via Tile_Num, then ranks them on the # they appear for that group via Tile_SequenceNum. I find this helpful as you could do a lot with this - sometimes you need it for every Nth count of a group to do something, you can use the tile tool as well. Hope this helped!