Loading
Prepare for Email to Become the Default Login ExperienceRead More
CRM Analytics
Inner Join

You are here:

  1. Salesforce Help
  2. Docs
  3. CRM Analytics

Inner Join

In CRM Analytics, an inner join includes only matching rows from the left (recipe data) and right. The join includes all matched rows in the target when multiple rows match.

Required Editions

Available in Salesforce Classic and Lightning Experience.
Available with CRM Analytics, which is available for an extra cost in Enterprise, Performance, and Unlimited Editions. Also available in Developer Edition.

Example

Our company's marketing team captures demographic data in an external data source for opportunities stored in Salesforce. To compare opportunities by education level of the customer, let’s first combine both sets of data into a dataset using an inner join.

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.

The left data stream shows the opportunity ID, customer name, and opportunity amount. The right data stream shows the opportunity ID and educational level.

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

The new dataset contains columns from both data streams.

All rows that have a match are included in the target. Because of multiple matches, you see two records with Opp_ID 2 (Amy and Bob) and two records with Opp_id 1 (High School and Secondary School). Notice also that Opp_ID 4 and Opp_id 5 are excluded from the target because neither have a match.

See Also

 
Loading
Salesforce Help | Article