topic Re: Merging or appending data to existing feature class field in Geodatabase Questions

Merging or appending data to existing feature class field

RomanFox — Thu, 27 May 2021 01:29:28 GMT

I hope this is the correct location and a simple question. I am looking to add or append data to an existing feature class field. I have an existing feature class that contains an ID field and a "Special" field among others. I have a standalone table with a ID field and a "Special" field. The feature class has ~15,000 objects and the standalone table ~1,500. I would like to use the ID in the stand alone to add the text in the data table's "Special" field to the feature classes "Special" field. For example in ID 123 is in the standalone table with "existing" in the "Special" field, then I would like the feature class to show "existing" in the Special note for ID 123.

Thoughts?

Re: Merging or appending data to existing feature class field

Anonymous User — Thu, 27 May 2021 01:30:37 GMT

Use Join.

Re: Merging or appending data to existing feature class field

RomanFox — Thu, 27 May 2021 01:45:05 GMT

Can this be done without creating a new field? I have used the Join Field tool. However, it created a new field. I would like to have the existing data in the text field remain and the new data from the standalone table added.

Re: Merging or appending data to existing feature class field

Anonymous User — Thu, 27 May 2021 01:55:30 GMT

Use Append.
🙂

Re: Merging or appending data to existing feature class field

Raj-Chavada — Thu, 27 May 2021 02:12:50 GMT

Agreed that Append GP tool is the right tool for appending new data.

For updating existing records- take a look at this documentation https://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/relating-the-attributes-in-one-table-to-another.htm

You may able to accomplish this by creating first Relate between FC and Standalone table in map document. Afterwards, you can use select by attribute followed by calculate field.

Re: Merging or appending data to existing feature class field

RomanFox — Thu, 27 May 2021 17:39:35 GMT

This has been helpful, I am stuck at the calculate field step with the sql expression. I am trying to add the "Special" field to the "Appended" field if "Appended" is <NULL>. Does this seem logical, and if so do you know of a resource for the sql or python expression?