topic Re: How to add data to attribute column in ArcGIS Pro Questions

How to add data to attribute column

Mikhail — Thu, 09 Sep 2021 03:17:33 GMT

Hello, I am a new user and have a big problem moving the data to and from ArcGIS. I have a layer with an attribute table so that the each FID is related to a specific polygon. I also have an Excel table with the same number of rows and some extra data for the each FID. My plan is to add this data to the attribute table so that eventually I create a map showing the distribution of this data. Sounds simple, but copy & paste does not work, and for some reason I can't link the two tables by the FID column. Could you help please?

Re: How to add data to attribute column

DanielSimo — Thu, 09 Sep 2021 03:38:32 GMT

Hi @Mikhail - Esri provides a number of tool to assist users loading data from external files into ArcGIS. The below tools will help you with what you are trying to achieve:

ArcGIS Solutions - Data Loading Tools

Object Loader and Simple Data Loader Tool

Excel To Table Tool

Append Tool

I hope that helps.

Regards

Re: How to add data to attribute column

Mikhail — Thu, 09 Sep 2021 13:01:22 GMT

Thank you for your response. I finally managed to join the two tables using the Join tool, but all I get is the column names from the source table copied into the attribute table. With this I have two problems. First, the columns with matching names get duplicated. Second, the content is lost, and instead of the data from the sources table I only get <Null>. Is there any way to solve this problem?

Re: How to add data to attribute column

TonyDeLaRosa — Tue, 14 Sep 2021 00:00:46 GMT

Before performing the Join, double check the datatypes on the joining fields are the same. You may be trying to join a string to double or something. This may be your issue. Also if you're using excel, try to export it to table.

Re: How to add data to attribute column

Mikhail — Sat, 25 Sep 2021 00:12:03 GMT

Thank you, it works now!