Copy a row in a GDB Table to same GDB Table

1151
9
Jump to solution
02-15-2023 08:43 AM
CarsonG
Occasional Contributor III

Is there a way to copy and paste a row from a GDB Table to the same GDB Table similar to copying and pasting a row in Excel.

 

0 Kudos
1 Solution

Accepted Solutions
DavidPike
MVP Frequent Contributor

Sorry it's been a while since using Pro at the coalface.  I've found that if you highlight the row in the table then go to 'Attributes' next to the Create Modify Delete Select tools.

In that pane you can then right click on the feature name and click 'copy attributes'.

Select the new line (create/add another row if you haven't already) then the attribute pane will update to show the newly selected row.  Right-click on the feature name and click 'Paste attributes'

Apply edits in the attribute pane and save the layer edits.

View solution in original post

9 Replies
CarsonG
Occasional Contributor III

Also, don't use copy rows. It will wipe out your existing table. Please fix your tool description in ArcPro for Copy Rows.

CarsonG_0-1676480155790.png

"Copies the rows of a table to different table" implies that you are copying the rows from one table to another table as long as the fields match.

The following statement from Copy Rows (Data Management)—ArcGIS Pro | Documentation means something entirely different.

  • The tool copies the rows of a table, table view, feature class, feature layer, delimited file, or raster with an attribute table to a new geodatabase or dBASE table or a delimited file.

 

CarsonG
Occasional Contributor III

David,

When using the described method in that link for GDB Tables, I get the following when pasting.

CarsonG_0-1676481571115.png

If I try to do paste special, I get the following.

CarsonG_1-1676481641428.png

That would be the methods I use for copying and pasting and feature into the same feature class or a new feature class. This does not appear to work for GDB tables.

0 Kudos
DavidPike
MVP Frequent Contributor

Ah ok, is this just a means to an end? can you export that record out (select that row only then export) and append back in to the table or merge and create a new one?

0 Kudos
CarsonG
Occasional Contributor III

If that is the route, I have to go. Seems like a roundabout way of doing something that should be very simple. If that process takes me a minute, it is 60 times slower than what a copy/paste would take.

Thanks for the help.

0 Kudos
DavidPike
MVP Frequent Contributor

Sorry it's been a while since using Pro at the coalface.  I've found that if you highlight the row in the table then go to 'Attributes' next to the Create Modify Delete Select tools.

In that pane you can then right click on the feature name and click 'copy attributes'.

Select the new line (create/add another row if you haven't already) then the attribute pane will update to show the newly selected row.  Right-click on the feature name and click 'Paste attributes'

Apply edits in the attribute pane and save the layer edits.

CarsonG
Occasional Contributor III

Thanks David! Knew there had to be an easy way of doing this!

CarsonG
Occasional Contributor III

Additional note, for this. Copy Attributes is dependent upon the Field Mapping found in the Transfer Attributes tool. 

0 Kudos
Bud
by
Notable Contributor

As of ArcGIS Pro 3.1, it's possible to duplicate a record in a standalone table using the duplicate context-menu option in the attribute table.

Bud_1-1714049376250.png

Implemented Idea: Ability to edit standalone tables in ArcMap just as easily as feature classes

Copy and paste a non-spatial record in the same table (make a duplicate a record)

Copy and Paste Selected Table Rows in Standalone File Geodatabase Table