An inner join includes only matching rows from the left and right input data source objects. The join includes all matched rows in the output data when multiple rows match.
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 using an inner join.
To illustrate how this batch data transform function handles unmatched rows and duplicate keys, we included them in both input data sources.
After performing the inner join based on the matching keys, the batch data transform produces the following output data.
All rows that have a match are included in the output. 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.