Left Join

Example

Our company's marketing team captures demographic data in an external data source for opportunities stored in Salesforce. To help create more targeted campaigns, the team is segmenting our current opportunities by the Education Level demographic. Let’s use a left join to add demographic data to the opportunity data.

Consider the following two data streams that feed the recipe’s target dataset. To illustrate how this recipe function handles unmatched rows and duplicate keys, we included them in both data streams.

After performing the left join based on the matching keys, the recipe produces the following target dataset.

All rows from the left, including rows without a match and rows with multiple matches, are included in the target. Because Opp_ID 1 has two matches on the right (High School and Secondary School), the target contains a separate record for each education level. Also, because Opp_ID 4 doesn’t have a match, the Opp_id and Education Level columns are null for that record.