Lookup on an different table to fetch data | Community
Skip to main content
D
dipendu_g
Level 5
July 7, 2022
Solved

Lookup on an different table to fetch data

  • July 7, 2022
  • 2 replies
  • 2676 views

Hi All,

 

In a workflow, that I have created to send emails, I get the initial data from an external table, which I enrich with the ACC Recipients table. After the enrichment, I get the "Country" of the contacts, which is need to query on another external table, which will give me the value against each contact. This value along with other recipients value, I need to be present in the Email Delivery, that I send next.

 

The issue is if I add another enrichment after the Recipient enrichment, I get the value but the Delivery fails as it expects Recipient Schema. 

 

Can you please suggest some solution to achieve this, where I can fetch the hash value, and also send the delivery

 

Regards,

DG

 

 

 

 

 

 

 

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 CedricRey

@cedricrey , At what stage I need to use the CD activity. the CD activity was not identifying the Recipients for me. Will you be able to guide me

 

Regards,

DG


After the "Enrich" when you retrieve the corresponding recipient :

(Sorry for the screenshot, don't have access to english instance, only french at the moment, but you should understand)

2 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
July 7, 2022

Hello @dipendu_g 

 

You can use the change dimension activity to use the recipient schema for delivery,

Manoj     Find me on LinkedIn
D
dipendu_gAuthor
Level 5
July 7, 2022

The Recipient Schema is not showing up in the Change Dimension Activity

 

Regards,

DG

D
dipendu_gAuthor
Level 5
July 7, 2022

Then you will have to use the enrichment activity to reconcile the data with the recipient on the basis of your email or another identifier.


Hi Manoj,

 

Step 1 - Gettig Data from External Table

Step 2 - Enriching with Recipient

Step 3 - Using Recipient country to fetch data from another table (external)

Step 4 - Change Dimension to revert back targeting dimension to Recipient - ( I am unable tp see the Recipient dimesnion here )

Step 5 - Email Delivery

If you see, I am enriching the data on Step 3, again, I need to enrich back ?

 

Regards,

DG

CedricRey
CedricRey
Level 5
July 7, 2022

Hi @dipendu_g ,

If you send the email from the workflow, and don't need to keep the datas after the sending, you can use temporary datas, from the workflow, with the next syntax :

<%= targetData.mydata %>

where "myData" is the name of the data in the workflow (you can use alias into the query or enrich activity, for more convenient manipulation).

 

Cedric

D
dipendu_gAuthor
Level 5
July 8, 2022

Hi Cedric,

 

I have an external table with the following columns

Contact MailInstitutionScore
aa@bb.comInstitution 150
aa1@bb.comInstitution 175
aa2@bb.comInstitution 285

 

In Step 2 I enrich this with Recipients to get the Country

 

This country I need to lookup on another external table to fetch the url, 

CountryUrl
Australiahttps://xxx.yyy.com#aus
New Zealandhttps://aaa.bbb.com#nz

 

In the final email, I need all the fields, contact ( to send mail ), institution, score and url

Request if you can tell the way to achieve the same

Regards,

DG

 

D
dipendu_gAuthor
Level 5
July 8, 2022

Any suggestion @_manoj_kumar_ @cedricrey 

 

Regards,

DG

Terms & ConditionsAccessibility statement

Loading footer...