Creating UPSERT dataflow from DLZ into a XDM Individual Profile class schema

[FlorijanGa]

Hi everyone,

I have tried reading the documentation but it's pretty unclear how to do this.
Let me explain the situation, to put it simply, we have a XDM Individual Profile class schema, with its dataset. We need to do a partial profile update (updating one object in a profile using the primary ID). Basically the primary dataflow brings all the data except the one object which comes from this dataflow.

I updated the dataset with "isUpsert:true" to the unifiedProfile tag, but seems it still acts like create and just takes the last insert as the whole profile.

To be more specific we are uploading test data over DLZ, and should later connect the dataflow to a GCS bucket.

Thanks in advance.

[abhinavbalooni · Accepted solution]

Hey @FlorijanGa 

I assume when you mentioned above you read the documentation, you referred to this link ? https://experienceleague.adobe.com/en/docs/experience-platform/catalog/datasets/enable-upsert

Basee on what you just mentioned, it should work except there is one thing you need to ensure. If this is an existing dataset, enabled for profile, then you would first beed to disable it for profile then set the upsert flag to true and then enable it back for profile.

Did you follow the above steps in order?

Cheers,

Abhinav

[CDresslerKYN]

FYI, I just ran into this exact issue (existing dataset enabled for profile). I figured it out on my own by just trying some combinations, but you should really update your document to reflect this use case and save people a lot of frustrating troubleshooting of this issue.