Select to view content in your preferred language

Attribute Rule to check for duplicates on a numeric field

768
3
10-25-2023 12:56 PM
avonmoos
Regular Contributor

I'm trying to create an attribute rule which would alert me of a duplicate value being entered in my dataset. The field I want to identify duplicates in is formatted as numeric and every expression I try I get an error expecting string values. I've been unsucessful at mofiying the code to work. Any Ideas?

0 Kudos
3 Replies
Robert_LeClair
Esri Notable Contributor

Yes!  There's a great Technical Support article here that describes the exact workflow to use.  Good luck!

avonmoos
Regular Contributor

Part way there...There's a note on that workflow stating

Note:
The attribute rule to identify duplicate field values in the attribute table only works for a text field.   

 

The only work around I could find for a numeric field would be to create an additional field and setup a rule to calculate my numeric value over as text and then run that workflow. I rather not have a duplicate field but may have to go that route.

0 Kudos
Robert_LeClair
Esri Notable Contributor

Ah - you're right!  I did find an Esri Community post that uses Validation Rules for duplicates.  You can read about it here.