topic Re: Copy and Paste Fields from Different Standalone Tables (ArcGIS Pro) in ArcGIS Pro Questions

Copy and Paste Fields from Different Standalone Tables (ArcGIS Pro)

JasonBritton1 — Tue, 01 Feb 2022 20:52:34 GMT

I feel like this is going to be a "oh yeah, that was obvious" moment when I get answers, but I'm at a bit of a loss. I've got an excel table with a list of about 2500 road names that I want to paste into the Address Data Management Solution's Master Road Name Table. When I do a copy/paste it only pastes about 10 records and it tries to fit them in one field.

I've tried to add the excel table to the map and do a join, but that doesn't seem to work. I've tried to calculate the field, but I can't select another table for my input info. Any ideas will be much appreciated.

Re: Copy and Paste Fields from Different Standalone Tables (ArcGIS Pro)

JasonBritton1 — Tue, 01 Feb 2022 21:04:38 GMT

Workaround seems to be append. Has to be a better way though.

Re: Copy and Paste Fields from Different Standalone Tables (ArcGIS Pro)

AdrianWelsh — Tue, 01 Feb 2022 22:36:02 GMT

Jason,

If you're copying records (rows) from a table that has the same attributes (fields/columns) as your feature layer that you're copying into, it seems that Append is a good tool to use for this. What problems have you found with append?

Maybe Copy Rows could be an option too (depending on what you're doing)?

https://pro.arcgis.com/en/pro-app/2.8/tool-reference/data-management/copy-rows.htm

Or maybe even copy features?

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/copy-features.htm

(perhaps just plain copy and paste: https://pro.arcgis.com/en/pro-app/latest/help/editing/copy-and-paste-using-the-clipboard.htm)

Re: Copy and Paste Fields from Different Standalone Tables (ArcGIS Pro)

JasonBritton1 — Tue, 01 Feb 2022 22:47:04 GMT

You can’t use copy features because there are no features in standalone tables. I’m copying, columns not rows. Append is a good workaround if you use the field map, but it’s still a little clunky.

Re: Copy and Paste Fields from Different Standalone Tables (ArcGIS Pro)

AdrianWelsh — Tue, 01 Feb 2022 23:04:33 GMT

Oh ok, I thought you mentioned copying records/rows.

The way I do it is first select the layer in the table of contents. Click on the Data tab at the top, then the Fields button. This opens up your fields (columns).

From here you can select as many fields as you need to and Copy them to the clipboard. Then you can paste those same fields (columns) into your other feature class by selecting that feature class (or table), going to Data and then Fields (like before) and just doing a Paste. I hope this helps!

Re: Copy and Paste Fields from Different Standalone Tables (ArcGIS Pro)

LyonMNGIS — Mon, 07 Feb 2022 14:46:50 GMT

I recommend that you import the excel table into a Geodatabase first using the table to table geoprocessing tool.