topic Re: Can an Arcade Attribute Rule access attributes from a related table field to populate/calculate a feature class field?? in ArcGIS Pro Questions

Can an Arcade Attribute Rule access attributes from a related table field to populate/calculate a feature class field??

BenjaminGrover — Wed, 05 Feb 2020 22:49:04 GMT

I feel like I'm trying to do something very simple, but Arcade is kicking my butt so far. All I want to do is populate a field in my feature class layer with the result of a simple field calculation that multiples one integer field by a field from a 1 to many related table... In my situation, there may be many features from my layer, that are related to just 1 table record. Any help would be appreciated. arcade script attribute rules rules‌@

#arcade‌ arcade expressions #arcade attribute expressions

Re: Can an Arcade Attribute Rule access attributes from a related table field to populate/calculate a feature class field??

BenjaminGrover — Thu, 06 Feb 2020 15:46:14 GMT

Here is what I've come up with, the error I get is that the output is resulting in a NaN, or Infinity.. I'm not sure how to address that.

var ShpSize = Area($feature, 'square-feet');

var RelTblFld = FeatureSetByName($datastore, "RelatedTableName", ["LongIntField1"]);

var Output = Round((RelTblFld)*(ShpSize), 2);

return Output

Re: Can an Arcade Attribute Rule access attributes from a related table field to populate/calculate a feature class field??

WillHouston — Thu, 02 Apr 2020 13:11:15 GMT

How many items are you trying to multiply together to get the result? Do you have a relationship class set up for the 1:Many relationship? You could try something like:

var results = FeatureSetByRelationshipName($feature, "relationship_class_name", ['LongIntField1'], false);
product = Area($feature, 'square-feet')
for (var r in results) { product = product * r.LongIntField1; }
return product;

I might be misunderstanding which sign of the 1:many relationship you're trying to access, but it should work either way. If you're multiplying something from the 1 side to the many side, just replace the for loop with

var r = First(results);