---
schema_version: "1"
id: 28f26e81aba4aa1765066f0471946ce61dd33d687b7e3f1dc8222cde005195f3
title: Use a Join Node on the Add Input Data Screen (Salesforce Objects Only)
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_join_recommendations.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_join_recommendations.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 3fd538f334f355c5ef0e958f177a1147330a3c76f31948a41d3edcb704064f00
description: When working with Salesforce objects in CRM Analytics, you can create your dataset and join data source in one step on the Input Data screen. Add Input Data also recommends columns that match each of your data sources and can serve as join keys.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Use a Join Node on the Add Input Data Screen (Salesforce Objects Only)

When working with Salesforce objects in CRM Analytics, you can create your dataset and join data source in one step on the Input Data screen. Add Input Data also recommends columns that match each of your data sources and can serve as join keys.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
      <colgroup>
        <col style="width:50%">
        <col style="width:50%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d70198e34">User Permissions Needed</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d70198e34 ">To manage and create a recipe:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d70198e34 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>

        </tr>
      </tbody>
    </table>

1. From the Add Input Data screen of a Data Prep recipe, select an object. This object is the left side of the join operation.
    
    ![Select an object from the Add Input Data screen](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_data_prep_join_input.png)
2. In the right pane, the Related Objects tab lists the columns that have other objects related by a matching column. The selected related object is the right side of the join operation. When you select one, a number appears in the left column to indicate the order in which it was joined.
    
    ![Recommended join keys display under the Related Objects tab](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_data_prep_related_object.png)
3. Click **Next**.
4. The recipe displays the joined objects.
    
    ![Joined Salesforce objects display in a Data Prep recipe](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_data_prep_join_result.png)