Copy and paste data from one attribute table to another?

MariaZumkeller — Fri, 07 Apr 2023 18:34:44 GMT

Is there any way to copy data from one field and paste it to another? Or, how can i pull this data out, edit in bulk (like in excel) and re-upload?

Also, ss there any way to quickly combine two fields in an attribute table into one without using join/relate? For example, if I have two text based values how can I add them?

Re: Copy and paste data from one attribute table to another?

DavidPike — Sat, 08 Apr 2023 19:24:54 GMT

You can copy/paste the data from Excel to the attribute table directly. Just be sure about how your data has been sorted. Consecutive rows and columns can also be pasted-in. I believe new rows are created if the paste count exceeds the current number of rows.

For combining 2 column values you can use Calculate Field (right-click on the column heading in the attribute table and Calculate Field button or GP tool https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/calculate-field.htm). You then build a simple expression using Arcade or Python e.g. in Python to add 2 string fields with a space between:

!FieldName1! + " " + !FieldName2!

I generally avoid doing this on a field that currently contains data unless I'm absolutely sure of the expression. Generally I find it best to create a new field and calculate the values into that. I understand that edits can be undone but mistakes happen.

topic Copy and paste data from one attribute table to another? in ArcGIS Pro Questions

Copy and paste data from one attribute table to another?

Re: Copy and paste data from one attribute table to another?