I need to find duplicates by comparing to fields. I am not sure how to accomplish this so any help would be appreciated.
I have two fields that i need to compare, Account and Acres1 fields. if there is not duplicate then put a "0" in the duplicate field for that record.
The end scenario i need something like this.
Account Acres Duplicate
D54963 12.43 0
D54963 12.43 1 (duplicate)
D54963 12.43 2 (duplicate)
D45879 26.32 0 (no duplicate)
D45879 17.32 0 (no duplicate)
D36540 17.51 0
D36540 17.51 1 (duplicate)
D36540 17.51 2 (duplicate)
D36540 17.51 3 (duplicate)
I have the following code but it only checks one field (Account) and it add a number to all attributes if there is a double not exactly what i need.
#create the field for the count values
#creating the list with all the values in the field, including duplicates
for row in cursor1:
del cursor1, row
#updating the count field with the number on occurrences of field_in values
#in the previously created list
for row in cursor2:
del cursor2, row