- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Cedric,
I have an external table with the following columns
| Contact Mail | Institution | Score |
| aa@bb.com | Institution 1 | 50 |
| aa1@bb.com | Institution 1 | 75 |
| aa2@bb.com | Institution 2 | 85 |
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,
| Country | Url |
| Australia | https://xxx.yyy.com#aus |
| New Zealand | https://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
Views
Replies
0 Likes
Total Likes