nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Creating new Columns in Attribute table

DEVANBarrett

Running the latest ArcGIS Pro version. I just recently got hired to a company building map products based on field collected data. The map I am creating has data spread across a handful of excel sheets. The attribute table that my map is running has a column of data missing. I am trying to figure out how to add said data so that I can adjust my legend to represent the missing data. Is there a way in ArcGIS Pro to just add the data directly, it is a very small amount. Or do I have to export said table, open, add the data in excel and then reload the table?? I used ArcGIS/ArcMap but it has been 10 years since the last time and am extremely rusty.

Find more posts tagged with

Desktop

Feature Services

Accepted answers

All comments

BarryNorthey

In Layout view --> right click on the target Table Frame in the Contents pane --> click Add Field (at the top) --> pick the new field(s) to add to the Table Frame display.

CaitlinOtt-Conn

@Angelica is there another step necessary in order for that newly created column and associated data to be visible in the layout view? I am trying to add a table and the new column is not appearing as an option in the table frame. Thanks!

Angelica

Hopefully you got this figured out since it was a long time ago but for anyone that clicks on this hoping for answers and is still confused, Clicking add new field does indeed make a new column in the attribute table. It looks like it makes a new row because it takes the list of columns and turns them horizontally in fields view, but when you go back to the attribute table you will see that a new column has been made. Hope this helps

DEVANBarrett

You are correct Johannes, I am trying to add a column (Vertical) to a table.

When I open the attribute table to the layer I am working on, there 5 vertical columns. There is a separate excel table that has 2 extra columns of data that I need to add to the original attribute table to properly display them onto my map. I am running into the roadblock of how to add the extra data and still keeping them attached to the layers specific polygons.

JohannesLindner

I think you're mixing up your terms.

In ArcGIS, and I believe in most database management systems, "column" (or "field") means the vertical parts of a table, while "row" means the horizontal parts. More info: https://pro.arcgis.com/en/pro-app/latest/help/data/tables/tables-in-arcgis-pro.htm

"Joining two tables" means adding some or all columns of Table1 to Table2, based on the equalness of a column in both table. More info: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm

Based on your mixup, I think you might be interested in appending Table1 to Table2. This takes all rows of Table1 and copy/pastes them into Table2. More info: https://pro.arcgis.com/en/pro-app/2.9/tool-reference/data-management/append.htm

If you want to add new rows manually, it depends on whether you work with a pure table or a table with a geometry field (Shapefile or Feature Class).

For tables:

open the attribute table, scroll down
click where it says "Click to add new row"
A new row gets created, you can input your values.
Save your edits

For Feature Classes:

open the feature creation panel
in the panel, click on the feature template you would like to create. If you click on the arrow to the right, you can input the attributes of the feature.
Choose one of the geometry creation methods and draw your feature on the map. FInish by clicking on the button, pressing F2 or double-clicking.
Save your edits.

BarryNorthey

To add a field (column) to a table, Pro opens up a Fields View of the target table as shown in Johannes' screen captures. Each field in the target table occupies (is defined in) a row in Fields View. This where you define the new field's structure (Name, Data Type, etc) --> Save --> close. The new field will appear in the target table ready for use.

DEVANBarrett

Hey Johannes, thanks for the information but I am looking at creating a new Column, not a new row. I think that I need to Join two tables but I was messing up the proper steps to do just that.

JohannesLindner

Open the attribute table, click on Add Field
Enter your field info
Save your changes

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.