topic Re: Arcade Field Calculation Error in Developers Questions

Arcade Field Calculation Error

DylanW_TOC — Wed, 12 Apr 2023 19:26:55 GMT

I'm struggling to complete a field calculation using Arcade. I'm trying to calculate a field in table 1 based on a field from table 2. Both tables exist in the same file geodatabase.

var commericalLine = FeatureSetByName($datastore,'CommericalLine_Table') if ($feature["FACILITYID"] == commericalLine["FACILITYID"]) { return 1 } else{ return Null }

When I go to validate the expression, I receive the following error message:

Invalid Expression.

Error on line 3

Dictionary type expected.

Any suggestions on how to resolve this?

Re: Arcade Field Calculation Error

KenBuja — Wed, 12 Apr 2023 19:51:44 GMT

FeatureSetByName returns a FeatureSet, not a single feature. You have to get a feature from that FeatureSet to do the comparison. If you're expecting there to be one feature, then you can use First to return that feature. If there are multiple features in that FeatureSet, you'll have to loop through them or use a Filter to get a specific one. If you use a Filter, remember that function will also return a FeatureSet and you'll need to use First to get the single feature.

var commericalLine = FeatureSetByName($datastore,'CommericalLine_Table') var feat = First(commercialLine); if ($feature["FACILITYID"] == feat["FACILITYID"]) { return 1 } else{ return Null }

Re: Arcade Field Calculation Error

DylanW_TOC — Thu, 13 Apr 2023 12:19:50 GMT

Thanks for the response, Ken. I tried out the code below, but it only matched one record (out of 28k) when it should have matched 3k

var commericalLine = FeatureSetByName($datastore,"CommericalLine_Table") var feat = First(commericalLine) for (var f in commericalLine){ if ($feature.FACILITYID == feat.FACILITYID){ return 1 } }

Another thing, it took over 10 minutes to complete this calculation does that sound right?

Re: Arcade Field Calculation Error

KenBuja — Thu, 13 Apr 2023 14:53:30 GMT

Your code was taking so long since you were cycling through all 28K features in table 2 for each feature in table 1. And it wasn't finding the correct output, since you were comparing the first record in Table 2 to your feature, instead of the looped feature in table 2 ("feat.FACILITYID" instead of "f.FACILITYID").

Give this a try. It filters table 2 by the FACILITYID of the feature in table 1. If there is a corresponding record in table 2, then it return 1. Otherwise, it returns null (which isn't explicitly needed in this script in my testing)

var commericalLine = FeatureSetByName($datastore,"CommericalLine_Table") var id = $feature.FACILITYID var filteredTable = Filter(commericalLine, "FACILITYID = @ID") if (Count(filteredTable) > 0) return 1;