Using split on the emails of recipients using data of another linked table

[saurabh99]

How can I apply split for the blacklisted emails in recipients with having a preceding query on the transaction date (emails are not given in the Transaction Table). 

[Denis_Bozonnet]

Hi @saurabh99 

What is the data model between transaction and recipient? have you got an identifier in Transaction that will represent the recipient. maybe you need to build a link on email address (lowering and trimming blank of course)

If so, you would use an Enrichment activity to build the relation or alternatively, you would add the link between Ttransaction and Recipient in the transaction data schema directly... Might be easier this way.

Thanks

Denis

[saurabh99]

Hi Denis,

I forgot to mention that Recipient and Transaction Table are already linked in 1:N relation.

Thanks

[AkshayAnand]

Hi @saurabh99 

You  can use the attribute "No longer contact by any channel" to filter out the blacklisted recipients.

[Denis_Bozonnet · Accepted solution]

Hi @saurabh99 

The link needs to be defined as a 0-1 link in the Transaction data entity with the reverse link defined, the link in transaction is of type link and the reverse link would have its unbound proerty set to true, this way, you can look how the link between Recipient Delivery Log and Recipient is made in the Recipient Delivery Log data schema...

Otherwise you do the link via Enrichment but doing it as Data Schema level makes more sense as such link would be used over and over...

Thanks
Denis

[Sukrity_Wadhwa]

Hi @saurabh99,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!