Select to view content in your preferred language

Copy and paste data from one attribute table to another?

2266
1
04-07-2023 11:34 AM
MariaZumkeller
New Contributor

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? 

0 Kudos
1 Reply
DavidPike
MVP Frequent Contributor

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.

0 Kudos