topic Re: Calculate Field based on a Join for Hosted Feature Layer in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579219#M25435 <HTML><HEAD></HEAD><BODY><P>Hi - I am managing a hosted feature service in ArcPro.&nbsp; To update a text field, I joined an excel table that has updated info.&nbsp; Then I was going to use calculate field to replace the existing data but the process failed.&nbsp;</P></BODY></HTML> Tue, 30 Jun 2020 14:25:47 GMT E_-_EricaHahn__GISS_ 2020-06-30T14:25:47Z Calculate Field based on a Join for Hosted Feature Layer https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579215#M25431 <HTML><HEAD></HEAD><BODY><P>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<IMG alt="" class="image-1 j-img-floatend jive-image j-img-original" src="https://community.esri.com/legacyfs/online/435624_Picture1.png" style="float: right;" /></P></BODY></HTML> Wed, 23 Jan 2019 16:51:34 GMT https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579215#M25431 ReneAubut 2019-01-23T16:51:34Z Re: Calculate Field based on a Join for Hosted Feature Layer https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579216#M25432 <HTML><HEAD></HEAD><BODY><P>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&nbsp;should be able to do this calculation in ArcGIS Online directly, possibly applying the FeatureSetBy* functions&nbsp;access the table in the Arcade expression.&nbsp;</P></BODY></HTML> Wed, 23 Jan 2019 19:25:35 GMT https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579216#M25432 XanderBakker 2019-01-23T19:25:35Z Re: Calculate Field based on a Join for Hosted Feature Layer https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579217#M25433 <HTML><HEAD></HEAD><BODY><P>Hi - did you resolve this issue - I have the same problem.</P></BODY></HTML> Mon, 29 Jun 2020 16:24:54 GMT https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579217#M25433 E_-_EricaHahn__GISS_ 2020-06-29T16:24:54Z Re: Calculate Field based on a Join for Hosted Feature Layer https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579218#M25434 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp;<A href="https://community.esri.com/people/ehahn_nifc">ehahn_nifc</A>&nbsp;,</P><P></P><P>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).&nbsp;</P></BODY></HTML> Tue, 30 Jun 2020 13:07:55 GMT https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579218#M25434 XanderBakker 2020-06-30T13:07:55Z Re: Calculate Field based on a Join for Hosted Feature Layer https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579219#M25435 <HTML><HEAD></HEAD><BODY><P>Hi - I am managing a hosted feature service in ArcPro.&nbsp; To update a text field, I joined an excel table that has updated info.&nbsp; Then I was going to use calculate field to replace the existing data but the process failed.&nbsp;</P></BODY></HTML> Tue, 30 Jun 2020 14:25:47 GMT https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579219#M25435 E_-_EricaHahn__GISS_ 2020-06-30T14:25:47Z Re: Calculate Field based on a Join for Hosted Feature Layer https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579220#M25436 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp;<A href="https://community.esri.com/migrated-users/408291">E - Erica Hahn (GISS)</A>&nbsp;,</P><P></P><P>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.&nbsp;Is it possible to obtain access to a sample of the data?</P></BODY></HTML> Tue, 30 Jun 2020 21:25:41 GMT https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579220#M25436 XanderBakker 2020-06-30T21:25:41Z Re: Calculate Field based on a Join for Hosted Feature Layer https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579221#M25437 <HTML><HEAD></HEAD><BODY><P>Try using expression type = python 3.&nbsp; Worked for me when joining a csv. ArcGIS Pro v2.6</P></BODY></HTML> Thu, 24 Sep 2020 12:41:04 GMT https://community.esri.com/t5/arcgis-pro-questions/calculate-field-based-on-a-join-for-hosted-feature/m-p/579221#M25437 WillHughes 2020-09-24T12:41:04Z