Select to view content in your preferred language

How to copy a column between tables

1315
4
02-17-2023 02:31 AM
SandyShores
Emerging Contributor

Greetings

I have two files, one standalone table and one shapefile with attributes. I desire to move all values present in one column of the shapefile to the standalone table without the grueling process of moving every single value individually. The standalone table is completly empty, containing only the columns. 

Tags (3)
0 Kudos
4 Replies
DanPatterson
MVP Esteemed Contributor

usually you accomplish this via a join

Join Field (Data Management)—ArcGIS Pro | Documentation

but you need a common field between the source and destination table to match the entries


... sort of retired...
0 Kudos
SandyShores
Emerging Contributor

I kinda want to do it without joining because I will be sort of "formatting" the atribute table of the shapefile

0 Kudos
DanPatterson
MVP Esteemed Contributor

and that precludes a join?


... sort of retired...
0 Kudos
JohannesLindner
MVP Frequent Contributor

You canuse the Append tool: Append (Data Management)—ArcGIS Pro | Documentation

  • use the shaep file as input dataset
  • use the table as target dataset
  • set the field matching type to "Use the field map to reconcile field differences"
  • in the field map, remove the source for each output field, set the source of the target field to the input field you want to copy
    • for example, in this screenshot I'm copying the values of "Shapefile.NEAR_FID" to "Table.IntegerField"
      JohannesLindner_0-1676632877799.png

       


Have a great day!
Johannes
0 Kudos