Calculate Field based on a Join for Hosted Feature Layer

193
6
01-23-2019 08:51 AM
Highlighted
New Contributor III

In ArcGIS Pro, I have a hosted feature layer (produced from Survey123 Connect) and a standalone table from a local FGDB. I performed a join in order to update a field on the feature layer from data contained in the table. Performing the calculate, using Arcade, I get an error message about multiple OID

Reply
0 Kudos
6 Replies
Highlighted
Esri Esteemed Contributor

I would log this error at support, since I think this should be able without generating any error. At the same time I think you should be able to do this calculation in ArcGIS Online directly, possibly applying the FeatureSetBy* functions access the table in the Arcade expression. 

Reply
0 Kudos
Highlighted
New Contributor II

Hi - did you resolve this issue - I have the same problem.

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

Hi ehahn_nifc ,

If you could elaborate a bit on your specific problem in a new question, I would be able to look at he alternative of using Arcade to obtain what you want (even without a join). 

Highlighted
New Contributor II

Hi - I am managing a hosted feature service in ArcPro.  To update a text field, I joined an excel table that has updated info.  Then I was going to use calculate field to replace the existing data but the process failed. 

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

Hi E - Erica Hahn (GISS) ,

I am not a big fan of joining data directly to an Excel file (or using Excel data directly). I assume that Arcade will be able to access the data from the Excel (I have not tested this) and update the hosted feature service based on values from the Excel file. Is it possible to obtain access to a sample of the data?

Reply
0 Kudos
Highlighted
New Contributor III

Try using expression type = python 3.  Worked for me when joining a csv. ArcGIS Pro v2.6

Reply
0 Kudos