In ArcGIS Pro 3.1, an "upsert" functionality was added to the Append GP tool, allowing you to designate updates to existing records in addition to adding new ones. This blog post outlines the functionality and says:
Use the Matching Fields for Update parameter to update existing records in the target dataset based on matching records in the input dataset. In this example, each zoning polygon has a unique Zone_ID. Therefore, any records from the target with a Zone_ID that matches records in the input dataset will update with values from the input. Note: You can also match based on multiple matching fields.
Using ArcGIS Pro 3.4.3, we're not seeing this perform as described. Instead, a duplicate of the matching record is added from the Input Dataset with the new attributes and geometry, while the original persists and remains unchanged. The schemas of the two datasets match (though they are in different FGDBs), and we're using a shared unique ID field to match the target and input fields. Afterward, I can do a Select By Attributes for that ID and both the original and appended feature will select, implying that the Unique ID does match. Have tried with and without the Update Geometry option checked, as well as the Enforce Domains option. Have also tried using a Selection vs a Where Query for the Input features.
Basically, it's always just doing a normal append, despite configuring the tool's Update Options. Has anyone else encountered this or found a solution? We found another upsert-related bug addressed in 3.2, but this seems to be the opposite of the issue we're having.
