Insert data from 2 different schemas and send to recipients | Community
Skip to main content
d-wnuk
d-wnuk
Level 2
November 21, 2019
Solved

Insert data from 2 different schemas and send to recipients

  • November 21, 2019
  • 1 reply
  • 2399 views

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.

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 8) 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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    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

    1 reply

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    November 21, 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

      Terms & ConditionsAccessibility statement

      Loading footer...