topic Re: Append from Excel to Feature Dataset not matching in ArcGIS Pro Questions

Append from Excel to Feature Dataset not matching

DaveBodak — Mon, 15 Jan 2024 16:10:14 GMT

Hello,

I am looking to update a feature layer that has pre-existing data in it and I have an Excel datasheet that I imported into ArcGIS Pro that contains more data to be implemented.

Both the table and the feature layer have matching "Account ID" fields that I am referencing in the "Update Options" Section, but it will not add any data to the appropriate fields when I run the processing tool.

I know I have the source fields pointing to the correct column in the table because when I don't try to use the account fields for targeting it will add another 15,000 data points in the feature layer.

Thank you in advance to anyone for help!

Re: Append from Excel to Feature Dataset not matching

RhettZufelt — Tue, 16 Jan 2024 16:40:53 GMT

The Append tool is for adding (Apending) additional data to an existing dataset.

Sounds like you want to update values in existing features based on a table. One way is to use the Add Join tool to temporarily join the table based on Account ID field, then use the Calculate Field tool to update the existing columns from the joined table.

Re: Append from Excel to Feature Dataset not matching

RoderickPerendy — Wed, 28 Feb 2024 22:05:53 GMT

Hello Rhett,

Then why does the append tool have the Update Options and Matching Fields?

Re: Append from Excel to Feature Dataset not matching

RhettZufelt — Wed, 28 Feb 2024 22:26:58 GMT

Looks like they've added that as an 'upsert' option.

I must have misunderstood your original post, and thought you were trying to update attributes based on a common field, not add new features to the data at the same time. So, suggested an appropriate set of tools for that operation instead of one that has now added that functionality to it as well.

I will have to play with these options in the future when I get time and see what I can find out.

Re: Append from Excel to Feature Dataset not matching

matt_g_g — Mon, 29 Apr 2024 13:10:42 GMT

I'm experiencing a similar problem but trying to update a feature class from another feature class using a common field. It seems to add records if there are changes rather than update the existing record with the common ID.

In the case you've explained, is the data type seen as the same by ArcGIS Pro, i.e., the xlsx Account ID is a double or float and the data type in the feature class for the matching field is the same type?