Avatar

Level 3

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