topic Re: Is calculating a field based on another field from a joined table supported? in ArcGIS Online Questions

Is calculating a field based on another field from a joined table supported?

RobBlash — Tue, 07 Jan 2020 17:01:03 GMT

I have 2 hosted feature services, a "production" HFS and an "updated" HFS. The production data was published from Pro, the updated data was published as a HFS from a zipped GDB upload.

I've created the join in AGOL based on a common ID, and saved the join as an HFS view. I want to update attributes in the production data from values in the update table. The underlying production HFS is editable. Seems like this should all be doable, but I get errors with SQL or Arcade.

Re: Is calculating a field based on another field from a joined table supported?

XanderBakker — Tue, 07 Jan 2020 19:34:58 GMT

Hi Rob Blash ,

Not sure if there is a restriction on calculation based on fields from a joined table. In Arcade however, you don't need any joins to do this. You can just use the FeatureSetBy* functions to do the join on the fly.

What is the cardinality? Is is 1:1 or 1:n?

Re: Is calculating a field based on another field from a joined table supported?

RobBlash — Tue, 07 Jan 2020 19:43:53 GMT

Thanks Xander. I was hoping the join could do it for simplicity, but Arcade would work. The join in this case is 1:1.

Do you have any example scripts for updating using FeatureSet?

Re: Is calculating a field based on another field from a joined table supported?

XanderBakker — Tue, 07 Jan 2020 20:07:52 GMT

Hi rblash ,

I do have an example here. You should look at the second example. In your case it would be simpler since you have 1:1 relationship: Using FeatureSetBy functions in Arcade to drill-down to other layers and tables

If you have any questions we can look specifically at your use case.

Re: Is calculating a field based on another field from a joined table supported?

RobBlash — Tue, 07 Jan 2020 21:06:56 GMT

Thanks, I'll take a look