Calculate Field based on a Join for Hosted Feature Layer

Question

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

WillHughes · Answer

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

XanderBakker · Answer

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?

ehahn_nifc · Answer

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.