Enrichment Activity & Simple Join

3 replies
702 views
Translate All

Hi,

What does the below join condition mean in an Enrichment activity when we are doing a simple join?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

ParthaSarathyAccepted solution

Community Advisor

Hi @sanjana12 ,

Let consider a scenario where the input file has recipient data (firstname, email, mobileNumber, CustomerId). Now to enrich this temporary data with recipient schema, create a simple link by mapping CustomerId from file in 'Source' with CustomerId from recipient table in 'Destination'. So the matched records will get created a link with recipient table in the workflow.

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

ParthaSarathy

Accepted solution

Community Advisor

Hi @sanjana12 ,

Let consider a scenario where the input file has recipient data (firstname, email, mobileNumber, CustomerId). Now to enrich this temporary data with recipient schema, create a simple link by mapping CustomerId from file in 'Source' with CustomerId from recipient table in 'Destination'. So the matched records will get created a link with recipient table in the workflow.

Translate

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

S

Sanjana12Author

Level 6

So it's basically matching records based on a common field in both the temp and destination schemas?

Translate

ParthaSarathy

Community Advisor

@sanjana12 , yes.

Based on use case you can hardcode the value in 'Source' as well. Lets say, defining 'client' in Source and selecting @status from recipient table, will create a link between temp table and recipient table only for 'client' status.

Translate

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

Sign up

Login with SSO

Login to the community

Login with SSO