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

Question

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

costa_n11 · Accepted Answer

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

costa_n11 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO