Target mapping inner join

[druidajes]

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?

[Shubham_Goyal__]

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

[Denis_Bozonnet]

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