Lookup on an different table to fetch data

[dipendu_g]

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

[_Manoj_Kumar_]

Hello @dipendu_g 

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

[dipendu_g]

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

Regards,

DG

[_Manoj_Kumar_]

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.

[dipendu_g]

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

[_Manoj_Kumar_]

@dipendu_g 

You already have the recipient from the enrichment from step 2. Where did that go in the next steps?

[dipendu_g]

On Step 2, When I enrich my Targeting Dimension is now Recipient. After that when I enrich again, the TD changes to that Table.

But in Change Dimension, I am unable to go back to the Recipient TD

Hope, I could understand your question and answer it 

Regards,

DG

[CedricRey]

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

[dipendu_g]

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

[dipendu_g]

Any suggestion @_Manoj_Kumar_ @CedricRey 

Regards,

DG

[CedricRey]

If the initial datas come from an external source (for exemple a file), as @_Manoj_Kumar_  said, you'll have to change the dimension to retrieve the corresponding recipients. Ensure that the "keep extra datas" is checked (2nd tab 'Result').

This way, you'll send email to nms:recipient (and not to targets defined in an external file). And you can use the temporary datas with the "targetData.XXX" syntax. The "XXX" must be the name of the attribute or element (and not the label) in the temporary schema in the incoming transition of the delivery activity. That's why it could be better to use aliases.

[dipendu_g]

@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

[CedricRey · Accepted solution]

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)

[dipendu_g]

Hi Cedric,

Sorry, but I am unable to get this screen.

I am unable to see this

Regards,

DG

[dipendu_g]

Hi Cedric,

I got it now. Thanks a lot to help me and show me the screenshot.

Really appreciate

Regards,

DG