Identifying duplicates and returning a statement

[binsell]

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 :) 

[davidskaife · Accepted solution]

Hi @binsell 

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

workflow attached!

[binsell]

@davidskaife Amazing! I should of thought of using the summarise tool! Thank you for sending so quickly :) 

[binu_acs · Accepted solution]

@binsell another way of doing it

[caltang · Accepted solution]

@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!

[binsell]

@binu_acs Genius as always!!

[binsell]

@caltang Thank you so much!