Join Node: Add Related Columns of Data to the Recipe

Use a join node in CRM Analytics to add columns of data from related objects to existing data in a recipe. When working with CRM Analytics datasets and external objects, add a join node on the recipe canvas. When working with Salesforce objects, you can either create a join on the recipe canvas or join the data when you first create your dataset on the Add Input Data screen.

• Use a Join Node in the Recipe Canvas
  In CRM Analytics, create joins between Salesforce objects, external objects, and CRM Analytics datasets in a recipe.
• 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.
• Join Operations
  Data Prep supports these join operations.