Expand my Community achievements bar.

Target mapping inner join

Avatar

Level 1

Hello,

I have a question as to how this should be done:

I use two tables "recipient" and "contracts", with cardinality 1 to n (one person can have many contracts).

When making a delivery, I only want to send it to people who have the contract with paid status.(in the "target mapping" it does not let me do an inner join with the two tables)

How should I do it?

2 Replies

Avatar

Community Advisor

Hi @druidajes ,

 

Could you share more details on your query like what error you face and how you apply the join and also how you declared 1:N cardinality is it via Enrichment activity or is declared via schema, etc? 

 

Br,

Shubham

Avatar

Employee Advisor

Hi @Shubham_Goyal__ 

 

in your workflow, what you would do is to query Contracts and then use a Change Dimension activity to select Recipient as the targeting Dimension and then you add your delivery or do further segmentation...

This means that you would have to have a link explicitly defined in Contract to Recipient with the N cardinality represented via the revLink element....

Thanks

Denis