topic Re: Multiply with a field in another table in Arcade in ArcGIS Pro Questions

Multiply with a field in another table in Arcade

PetronellaHauptmann1 — Wed, 28 Jun 2023 13:01:17 GMT

Hi.

So I'm trying to create a forecast on how many kids there will be in an area for the next 10 years. I'm using attribute rules and multiply with a coefficient.

The Arcade-script looks like this and works as it should.

var year = $feature.ForegandeAr * Pow(0.993608803, 1);
return Round(year)

The thing is - the value 0.993608803 will change once or twice a year and it appears in a lot of attribute rules. I would therefore like that value (0.993608803) to be taken from another table where I can change it and it changes all the values in all attribute rules. But I don't know how. Can someone please help? Should I make a relationship class? Or a database view? How do I write it in Arcade? Or how can I solve this?

I've attached my gdb if someone needs it.

Thankful for your help!

Re: Multiply with a field in another table in Arcade

RhettZufelt — Wed, 28 Jun 2023 14:55:01 GMT

I have a stand alone table in the same database that I use for this kind of thing.

var tbl = FeatureSetByName($datastore,"InputTable",['Coeff'], False); var feat = First(tbl) var year = $feature.ForegandeAr * Pow(feat.Coeff, 1); return Round(year)

I grab the table and the field that I have populated with the value (in this case, 'Coeff').

Grab the fist row in that layer (even though there is only one (any other needed values are their own column)).

Use the value of the feat.Coeff field in the Pow() function.

Re: Multiply with a field in another table in Arcade

PetronellaHauptmann1 — Wed, 28 Jun 2023 20:15:55 GMT

That works great! Thank you!