Arcade Field Calculation Error

DylanW_TOC

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?

kenbuja

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 = <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/354972">@ID</a>")
if (Count(filteredTable) > 0) return 1;