topic Re: Attribute Rule to check for duplicates on a numeric field in ArcGIS Pro Questions

Attribute Rule to check for duplicates on a numeric field

avonmoos — Wed, 25 Oct 2023 19:56:08 GMT

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?

Re: Attribute Rule to check for duplicates on a numeric field

Robert_LeClair — Wed, 25 Oct 2023 20:16:15 GMT

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

Re: Attribute Rule to check for duplicates on a numeric field

avonmoos — Wed, 25 Oct 2023 20:32:33 GMT

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.

Re: Attribute Rule to check for duplicates on a numeric field

Robert_LeClair — Wed, 25 Oct 2023 20:36:01 GMT

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