Enrichment Activity & Simple Join

3 replies
677 views
Translate

Hi,

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

ParthaSarathyAccepted solution

New Participant

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

ParthaSarathyAccepted solution

New Participant

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

New Participant

@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