Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Insert data from 2 different schemas and send to recipients

Avatar

Avatar
Validate 1
Level 2
d-wnuk
Level 2

Likes

3 likes

Total Posts

16 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
d-wnuk
Level 2

Likes

3 likes

Total Posts

16 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
d-wnuk
Level 2

21-11-2019

Hi,

I'm looking for the way to insert data from 2 data schemas into delivery and send it over to recipients. I'm able to gather all necessary information from these 2 tables, however I'm struggling with adding them into delivery.
1857319_pastedImage_0.png

Above there is a current set up. The issue I encountered is in Enrichment 9: My primary set is from query where I'm looking for email address (recipient schema). There is added a link (type 1N) to temporary schema (enrichment 😎 and I can't select any matching source and destination expression to use a simple join.

Is it the way to combine data from 2 different schemas not linked with the recipient? Or maybe some workaround that will help to somehow reorganise the workflow?

Thanks for any suggestions.

Dominik

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

21-11-2019

Hi,

What you have is correct, though can be done with 1 enrichment, or 0 with schema-defined join.

For 1:n you have to go through the wizard to specify how many rows to pivot into cols- deliveries are only sent to a single row per recipient in the target table. If unlimited rows are desired you'll have to write some code, with a hit to sending perf (n recipients = n lookups).

Thanks,

-Jon

Answers (0)