Question on Qcing two layers against each other with Attribute rules via validation

Question

Hello,

I am working on a project where have a layer of existing and new addresses that require me to qc the new addresses to make sure they are not already in the existing layer. I attempting to utilize Attribute rules to create some sort of filter to circumvent having to go through the data by hand but my knowledge on arcade (and JavaScript which I have heard is similar) is nonexistent.

I attempted to go around this issue by using run data checks/feature on feature to create a formula to get converted into arcade and get the attribute rules to work. I have not yet been able to make this work either as my programming experience is sophomoric at best.

The idea would to be able to compare three different columns for address number/suffix/ address name against each other and have some sort of filer or new layer of results showing addresses that do not show up in the existing layer.

Any idea how id want to go about figuring out this process? Is there possibly an easier way to go about this that I am not seeing?

JayCary · Answer

If you're only comparing attributes, you could try using the new Duplicate Row check. This check identifies features that have duplicate attribute values in one or more columns.

This check was created (in part) to address a NG911 use-case to identify duplicate features with the same attribution in the same or different locations.

cordtsra · Answer

Hello, I think what you are looking for would be a table to table attribute check which can be found in the validation section of the ready to use attribute rules. If you add the validation check to the attribute rules for the existing address feature layer, you should be able to see the new address feature layer under the check parameters features/rows to compare (assuming your editor tracking and global ID's are turned on for both layers). Then in the where clause you would have a condition like Where existing address number is equal to new address number, and existing address name is equal to new address name. This would flag all new addresses that already exist in the layer. If you would like to flag ones that do not exist in the layer, then you can change to is not equal to. I hope this helps!