--- schema_version: "1" id: a774ec305f1451393df81c49dc3be8bf7fcd21157d99410d0fe0fdcb1ed86e48 title: Add More Data in a Recipe collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_data_prep_recipe_add_data.md canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_add_data.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 6e7a40d7fe313457732e92f1edf88b5e1dcbf5a4b22a4cb17a214e2bbd3baace description: "You can add columns of data from related objects to existing data in a recipe. Depending on how you want to combine the new data, use one of the following methods: lookup, left join, right join, inner join, or full outer join." products: - CRM Analytics - Cross Cloud release: "264" --- # Add More Data in a Recipe You can add columns of data from related objects to existing data in a recipe. Depending on how you want to combine the new data, use one of the following methods: lookup, left join, right join, inner join, or full outer join. ### 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.
![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png) Note To add columns from a related object in a Data Prep recipe, see [Join Node: Add Related Columns of Data to the Recipe](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_join_data.htm&release=264.0.0&type=5 "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."). To do it in a dataflow, see [augment Transformation](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_augment_transformation.htm&release=264.0.0&type=5 "The augment transformation adds columns to a dataset from another related dataset. The resulting, augmented dataset enables queries across both related input dataset. For example, you can augment the Account dataset with the User dataset to enable a query to return account records and the full names of the account owners."). Watch a Demo: [![Play button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/play_btn.png) Add Data in a Recipe (English Only)](https://salesforce.vidyard.com/watch/HM2JWBr3p9KHBifYckTaFb?) When you add data to a recipe, you select the dataset or connected object that contains the fields that you want to add. You also select the key fields to match the records between the existing and new data streams. For example, to add User fields to Opportunity records, use the User Id field from the User object and Opportunity Owner Id field from the Opportunity object as the keys. When defining the key, you can use a single field or, if necessary, multiple fields. Note that multivalue fields can't be used as keys. Let’s look at an example to illustrate how you add data. Imagine you started a recipe from an opportunities dataset, and you want to add more opportunity details from another dataset. You can use the opportunity ID field from each dataset as the keys. 1. On the recipe page, click the Add Data button (![Add data button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_add_data_button.png)). 2. Select either the Datasets or Connected Data tab, and click the dataset or object that you want to add. ![Select Dataset dialog](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_add_data_select.png) 3. Choose the join type. By default, Lookup is selected. ![The join types appear at the top of the Add Data page.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_join_selectJoinType.png) 4. Select the keys from the left and right data streams. The left data stream is the existing data. The right is the new data that you want to add. CRM Analytics suggests keys if it finds related fields. ![Select the keys.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_select_merge_keys.png) 5. To select additional keys, click **+Add Key Pair**. If needed, use multiple keys to match records. For example, imagine you’re adding contact information to lead data. Using names alone to match can result in duplicate matches when different leads have the same name. Use two keys to match on name and company to ensure you’re matching the right data. You can use up to 5 keys. ![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_important.png) Important CRM Analytics datasets contain date and time component fields, such as Year, Quarter, and Month, that are derived automatically from existing date and time fields. Use of these component fields as keys isn’t supported. 6. In the **Columns to Include** section, select the columns to include in the recipe. ![Select fields to add](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_select_fields_to_add.png) Only the key columns are selected by default. So make sure that you select all the columns that you need in the recipe. The columns are color coded to indicate their source. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png) Note The results preview can display up to 100 columns. Modify the preview or deselect columns to ensure that you can see just the columns that you need. 7. Click **Done**. Each time you add data, a new step is created in your recipe, and the added fields appear in your recipe preview. Hover over a step and click ![Actions button](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_replication_actions_button.png) to access the Edit and Remove options. ![Added fields in recipe preview](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_data_added.png) #### See Also - [Lookup](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_join_lookup_multivalue.htm&release=264.0.0&type=5 "In CRM Analytics, a lookup returns all rows from the left data stream (recipe data) and only matching rows from the right data stream (lookup source). If multiple matches are found in the right data stream, you can set the lookup to return either a single row or all matching rows. To ensure that the grain of the results doesn’t change, the lookup outputs one row for each row in the left data stream.") - [Left Join](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_transformation_leftjoin.htm&release=264.0.0&type=5 "Like a lookup, a left join in CRM Analytics includes all rows from the left (recipe data) and only matching rows from the right. Unlike a lookup, a join includes all matched rows in the target when multiple rows match.") - [Right Join](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_transformation_rightjoin.htm&release=264.0.0&type=5 "A right join in CRM Analytics includes all rows from the right and only matching rows from the left (recipe data). The join includes all matched rows in the target when multiple rows match.") - [Inner Join](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_transformation_innerjoin.htm&release=264.0.0&type=5 "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.") - [Full Outer Join](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_transformation_fullouterjoin.htm&release=264.0.0&type=5 "In CRM Analytics, a full outer join includes all rows from the left (recipe data) and right, regardless of whether they have matches. The join includes all matched rows in the target when multiple rows match.") - [Considerations When Using Joins](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_transformation_joinconsiderations.htm&release=264.0.0&type=5 "In CRM Analytics, unlike a lookup, a join creates a separate record for each match in the target dataset when multiple rows match. Before using a join, ensure that you understand the implications of duplicate rows.")