topic Re: Validation Rule to Flag Duplicate Values in Attribute Rules Questions

Validation Rule to Flag Duplicate Values

ChrisGAEG — Wed, 11 Aug 2021 20:13:20 GMT

Is it possible to create a validation rule that will flag or warn when a duplicate value is being added in a new feature's attributes? I'm new to Arcade and have very limited Javascript experience. Any input or help on this is greatly appreciated.

Re: Validation Rule to Flag Duplicate Values

HusseinNasser2 — Wed, 11 Aug 2021 21:01:59 GMT

 //detect duplicate
var currentAssetId = $feature.assetId
var currentObjectId = $feature.objectid
var fsMyClass = FeatureSetByName($datastore, "myclass")
var fsResult = filter(fsMyClass, "assetid = @currentAssetId and objectid <> @currentObjectId") // search for the same asset id but don't count the current row
if (first(fsResult) == null)
return true; //we did not find a duplicate 
else
return false; //we did find a duplicate create an error feature

A bit slow but should work.

Alternatively you can do a summary statistics on the class and detect where count > 1

Re: Validation Rule to Flag Duplicate Values

ChrisGAEG — Thu, 12 Aug 2021 00:34:54 GMT

Hi Hussein, thanks for you response. I applied the rule to a point fc, but nothing happens when I create a duplicate address. How do I get the flag to trigger? This is how I have the expression. I am testing locally and not on SDE database, before I apply to my orgs database.

//detect duplicate var currentAssetId = $feature.address var currentObjectId = $feature.OBJECTID var fsMyClass = FeatureSetByName($datastore, "Served_Address_copy") var fsResult = filter(fsMyClass, "address = @currentAssetId and OBJECTID <> @currentObjectId") // search for the same address but don't count the current row if (first(fsResult) == null) return true; //we did not find a duplicate else return false; //we did find a duplicate create an error feature

Are there any other steps I need to take to get this to trigger?

Re: Validation Rule to Flag Duplicate Values

HusseinNasser2 — Thu, 12 Aug 2021 00:39:06 GMT

Yes you will need to use the error inspector to trigger the validation rules. That will create an error feature showing you where the duplicates are

watch this youtube video where I show how to create and evaluate. Note that you can run validation rules and batch calculation rules on filegdb.

Re: Validation Rule to Flag Duplicate Values

ChrisGAEG — Thu, 12 Aug 2021 01:08:31 GMT

After creating the rule, I open the error inspector and when I click on the map (or the layer with the attribution rule) nothing comes up on error inspector. Is there something I'm missing? (I am on an advanced license).

Re: Validation Rule to Flag Duplicate Values

ChrisGAEG — Thu, 12 Aug 2021 01:21:02 GMT

Scratch that, I think I figured that part out. I will play with it a bit and see if I can get the rest. Thank you for your help so far.

Re: Validation Rule to Flag Duplicate Values

ChrisGAEG — Thu, 12 Aug 2021 19:29:07 GMT

Hi Hussein, I have one more question concerning this. How would this code change if made a constraint rule? Would it be drastically different?

Re: Validation Rule to Flag Duplicate Values

HusseinNasser2 — Thu, 12 Aug 2021 19:31:30 GMT

It should be identical