Select to view content in your preferred language

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

585
2
05-26-2023 02:49 AM
Labels (3)
PeterDouglassEPD
New Contributor II

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

0 Kudos
2 Replies
jcarlson
MVP Esteemed Contributor

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.

- Josh Carlson
Kendall County GIS
0 Kudos
PeterDouglassEPD
New Contributor II

file-based layers - shapefiles in a FGDB

0 Kudos