Append layer and transfer attributes that don't exist to target based on common field

JustPete — Fri, 26 May 2023 09:49:50 GMT

Hello,

I have trawled through the ESRI community and have tried to find a solutions, but struggling. I need to append a target layer and input layer using a common attribute (Parcel ID). The input layer will have duplicate values, but I want to keep the data from the target values, rather than update and append the target feature. Essentially, I want to run an append tool that will read the common field value (Parcel ID) - that exists in both target and input fields - identify differences in the input values, and append the data which doesn't exist in the target dataset from the input dataset.

I did try this solution (Solved: Re: Append only ids that don't exist in another cl... - Esri Community) however, couldn't get it to work, and don't want to create a new feature class, just append the target feature by transferring attributes which exist in the input, but don't exist in the target, and skipping duplicates.

Cheers

Re: Append layer and transfer attributes that don't exist to target based on common field

jcarlson — Fri, 26 May 2023 12:25:44 GMT

Are these file-based layers, or services? The simplest approach in my mind is to do an XOR join between the tables to get the non-duplicates in your source, then use that subset to append to your target.

Re: Append layer and transfer attributes that don't exist to target based on common field

JustPete — Tue, 30 May 2023 08:28:38 GMT

file-based layers - shapefiles in a FGDB

topic Append layer and transfer attributes that don't exist to target based on common field in ArcGIS Pro Questions

Append layer and transfer attributes that don't exist to target based on common field

Re: Append layer and transfer attributes that don't exist to target based on common field

Re: Append layer and transfer attributes that don't exist to target based on common field