Leiste mit Community-Erfolgen erweitern.

Submissions are now open for the 2026 Adobe Experience Maker Awards

Mark Solution

Diese Konversation wurde aufgrund von Inaktivität geschlossen. Bitte erstellen Sie einen neuen Post.

GELÖST

Insert records into Recipient and Custom Table

Avatar

Level 2

Hello,

We are using the Recipient table to store the customer attributes and also created a custom table to store several customer extension attributes. This is a 1:1 relationship.

I'm trying to insert records into the Recipient and the Custom table in a single workflow. Is this possible or do i need separate workflows for each Target dimension?

Any other suggestions on how to insert records into Recipients and the Custom table??

Thanks for your help

Sree

1 Akzeptierte Lösung

Avatar

Korrekte Antwort von
Community Advisor

Use reconciliation on key, or straight insert (no update) if that’s your use case.

Lösung in ursprünglichem Beitrag anzeigen

4 Antworten

Avatar

Community Advisor

Hi,

Have the 'Update data' activity for nms:recipient output a transition, then connect it to a 2nd update activity for your custom table.

The outgoing transition will have the pk's of the upserted nms:recipient rows to use for your custom table's recipient-id fk.

If the relationship is the other way (recipient table has fk's to custom table), reverse the above order.

Thanks,

-Jon

Avatar

Level 2

Thanks Jon.

I tried the approach and running into this error message. Do we need to perform any transformation before the 2nd Update activity?

06/26/2019 5:38:48 PM writer2 WKF-560029 The document types of inbound events ('srm:Custom' and 'nms:recipient') are incompatible (step 'Insert Recipients'). Unable to perform the operation.

Avatar

Korrekte Antwort von
Community Advisor

Use reconciliation on key, or straight insert (no update) if that’s your use case.

Avatar

Level 2

Straight Insert worked. I'll add the reconciliation step too. Thanks for your help