The upsert is set to look for a Key Field that is unique to each record, and when the initial record is created, it uses a pipeline to create that record in another App.
The problem is, when the Other app version of the record is updated, even when searching for the identical Key Field, it is not finding it, even though I have just created it using the other app.
I tried to screenshot these but the post wouldn't let me add them.
Updating table
10207 - Kroger - 6800-100 - 11-16B - 872
Original Source Table
10207 - Kroger - 6800-100 - 11-16B - 872
As you see, the fields match, so why would it not find it?