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; } } }

How do I select attributes from multiple records in a Table?

WalterWitt

I am correcting a Table created from an Excel spreadsheet that has attributes for about half the records switched into the wrong column. I am laboriously copying and pasting the incorrect attributes for each record, one by one. Is there no way I can select attributes from multiple records so the cut and paste process can be speeded up?

Finde mehr Beiträge mit dem Tag

Accepted answers

JakeSkinner

Hi Walter,

Instead of copying/pasting, you should perform the following:

1. Select all the incorrect rows

2. Right-click on the field that needs to be updated > Field Calculator

3. Set the field calculator to the field in which you wish to copy the values from

All comments

RebeccaStrauch__GISP

Walter, Jake's answer definitely answers your question, but you may want to go back to your Excel document, which I assume was the source, to see if you can figure out the reason for the shift. Chances are it is a formatting issue, such as having a comma or quote within a field, that is causing data to skip to the next field.

what process did you use? Direct from Excel or thru a .csv format....thru a tool or copy-paste? One of these help topics may help:

Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS for Desktop

Formatting a table in Microsoft Excel for use in ArcGIS—Help | ArcGIS for Desktop

An overview of the Excel toolset—Help | ArcGIS for Desktop

Adding a Microsoft Excel table to ArcMap—Help | ArcGIS for Desktop

Table To Excel—Help | ArcGIS for Desktop

WalterWitt

Thanks for the tip, Jake. I haven’t used Field Calculater before. I do wish though that it could be simpler (like in Excel)

Cheers

Walter

JakeSkinner

Hi Walter,

Instead of copying/pasting, you should perform the following:

1. Select all the incorrect rows

2. Right-click on the field that needs to be updated > Field Calculator

3. Set the field calculator to the field in which you wish to copy the values from

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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