Enrichment Activity & Simple Join

[Sanjana12]

Hi,

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

[ParthaSarathy · Accepted solution]

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.

[Sanjana12]

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

[ParthaSarathy]

@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.