Using split on the emails of recipients using data of another linked table | Community
Skip to main content
S
saurabh99
Level 2
September 6, 2022
Solved

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

  • September 6, 2022
  • 2 replies
  • 875 views

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

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 costa_n11

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

2 replies

C
Adobe Employee
costa_n11Adobe Employee
Adobe Employee
September 6, 2022

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

S
saurabh99Author
Level 2
September 6, 2022

Hi Denis,

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

 

Thanks

AkshayAnand
Community Advisor
AkshayAnandCommunity Advisor
Community Advisor
September 6, 2022

Hi @saurabh99 

 

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

 

 

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    September 14, 2022

    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!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...