Enrichment Activity & Simple Join

Forum|Forum|11 months ago
February 17, 2025
1 reply
665 views

Hi,

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

Best answer by ParthaSarathy

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

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.

~ 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?

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.

~ 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

Scanning file for viruses.

This file cannot be downloaded