topic How to copy a column between tables in ArcGIS Pro Questions

How to copy a column between tables

SandyShores — Fri, 17 Feb 2023 10:31:55 GMT

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.

Re: How to copy a column between tables

DanPatterson — Fri, 17 Feb 2023 11:14:49 GMT

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

Re: How to copy a column between tables

JohannesLindner — Fri, 17 Feb 2023 11:21:40 GMT

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"

Re: How to copy a column between tables

SandyShores — Fri, 17 Feb 2023 11:21:54 GMT

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

Re: How to copy a column between tables

DanPatterson — Fri, 17 Feb 2023 11:27:06 GMT

and that precludes a join?