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.
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?
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?
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.
Thanks, I'll take a look
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
