Insert records into Recipient and Custom Table

Avatar

Avatar
Validate 1
Level 2
sreev97350841
Level 2

Likes

8 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
sreev97350841
Level 2

Likes

8 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
sreev97350841
Level 2

26-06-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

26-06-2019

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

Answers (3)

Answers (3)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

26-06-2019

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

Avatar
Validate 1
Level 2
sreev97350841
Level 2

Likes

8 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
sreev97350841
Level 2

Likes

8 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
sreev97350841
Level 2

26-06-2019

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

Avatar

Avatar
Validate 1
Level 2
sreev97350841
Level 2

Likes

8 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
sreev97350841
Level 2

Likes

8 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
sreev97350841
Level 2

26-06-2019

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.