Adding Data to new Field

Question

Hi --

I am trying to figure out the easiest way to add data in bulk to a newly added field or column.  Ideally, I'd like to use a .CSV file to upload data in bulk, but if there are other ways outside of manually inputting into the table, please advise.

I know how to add a new field into the existing data, but am having trouble adding data into the new field.  Any suggestions/help would be greatly appreciated!

KellyGerrow · Answer

Hi Jason,

If you add a .csv file with the additional field as a table, you could add the new column of values to the existing hosted feature layer using the join features analysis tool, by matching unique fields. This video outlines this process:

ArcGIS Online Join Features Demo 3 – Join to a table based on common attribute - YouTube

-Kelly

MarisaClaggett · Answer

Make sure that all field types match as well.  Do all fields exist in the CSV as well or only the FID and sample field?

Also take a look at this:

"You must ensure the field values in the update file and the layer correctly and uniquely identify the feature to update. If the values do not, you could lose data when an update overwrites attributes for an existing feature. Update and append will fail if you update results in with nonunique values in a field you have identified as unique."

You can also try just running a join operation in Pro by pulling in the hosted layer, using the FID as the join field and adding the data directly to the service that way.  If none of that works, I would reccomend calling Esri support for assistance.

Thanks,

Marisa

JasonJu · Answer

Hi Marisa -

I'm still not able to append/update the data.  I'll walk you through the steps I'm taking, please let me know if you know where I am not doing something correctly.

* Added initial data and published as feature layer.
* I now need to create a new column, so I created a new field called "sample" from the Data tab.
* In the .CSV I also create a new column called "sample" with data below it.
* I then click "Update Data", and go into "Append Data to Layer".  Now I tried two different ways, both of which I am getting an error.  After uploading the newly updated .CSV with the "sample" column and data:* I un-click "Update existing features" and Continue.  I get an error ("Unable to append data.")
* The second way I did it is keep "Update existing features" clicked and I match the FID with the newly created field/column, "sample".  I get the same error (Unable to append data.).

Happy to share some screen shots if that helps, thank you!