Looking for information on copying the values in a field from on attribute table and pasting them in another table. Both have the same amount of entries and matching ID fields. Should be pretty straightforward but cannot seem to get it to work. On ArcGIS 10.2 with advanced license.

very similar question to what was asked a couple years ago here but original data is in another table than the destination: Adding new field in ArcMap from data of existing field?


1 Answer 1


Using the Join Field (Data Management) tool will join your tables. From there you can export your newly joined table and have a new table containing the fields you need. Or, you can use 'Field Calculator' and populate a newly created field, or an existing field, with the attributes from the joined table that you need.

Also, make sure the newly created field has a field-type that is able to be populated from the joined field. Integer-Integer, String-String and so forth

  • thanks @Maksim. how exactly would you do this using the field calculator if the fields are in different tables?
    – Fred
    Commented Sep 16, 2014 at 17:23
  • right click the field you want to populate, select Field Calculator. From there you can use VP Script or Python parser, select the field from the different table, and populate your field in the original table
    – Maksim
    Commented Sep 16, 2014 at 17:25
  • I mean, is there some particular code to select the field from the other table - the only ones in the "field:" box are from the same table
    – Fred
    Commented Sep 16, 2014 at 17:31
  • If they are successfully joined, your 'Fields:' box should contain all of the fields, prefixed by the table name. Table.OBJECTID and NewTable.OBJECTID for example
    – Maksim
    Commented Sep 16, 2014 at 17:34
  • oh right got it i was looking for a way to do it without joining the tables - not possible right?
    – Fred
    Commented Sep 16, 2014 at 17:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.