---
schema_version: "1"
id: 82af7025b858db584a279d86a9cd76a3bc57ee56c497cbc0e2a1383f35e5d7a8
title: Add Rows in a Recipe with Append
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_append_rows.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_append_rows.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: c1e1d43a8fbd73fd8240d35c15c5269d81d7a489c6929902a4555143a6008ba8
description: Use append to add rows to the data in your recipe from another dataset or connected object. Fields are mapped automatically, or you can map them manually.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Add Rows in a Recipe with Append

Use append to add rows to the data in your recipe from another dataset or connected object. Fields are mapped automatically, or you can map them manually.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in Salesforce Classic and Lightning Experience.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available with CRM Analytics, which is available for an extra cost in <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions. Also available in <strong>Developer</strong> Edition.</td></tr></tbody></table>

<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="d80111e47">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d80111e47 ">To create a recipe:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d80111e47 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>
          </tr>
        </tbody>
      </table>

![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 append rows in a Data Prep recipe, see [Append Node: Stack Rows from Different Sets of Data](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_append_rows.htm&release=264.0.0&type=5 "Use an Append node in a Data Prep recipe in CRM Analytics to stack rows from multiple sets of input data into one dataset. For example, use this node to combine sales records from two different Salesforce orgs, each containing sales transactions from a specific region."). To do it in a dataflow, see [append Transformation](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_append_transformation.htm&release=264.0.0&type=5 "The append transformation combines rows from multiple datasets into a single dataset.").

Let’s look at an example of how you can use append in a recipe. Imagine you’re a US company that uses separate Salesforce orgs for its US and Canada operations. You sync the US opportunities in your local org, and use a remote Salesforce connection to sync your Canada opportunities. You want to combine these US and Canada opportunities to create a single North America opportunities dataset.

![Two tables of data, one of US opportunities, one of Canada opportunities](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_recipe_append_tables.png)

You’ve already started the recipe from your synced US opportunities (1), to which you now want to append data from your synced Canada opportunities dataset (2). Notice that the fields are not exactly the same. The US data has an Amount field and the Canada data has a Value field. The US data has a Lead Source field, which the Canada data doesn’t have. These kinds of differences affect how appended fields can be mapped to fields in the recipe.

- Appended fields are mapped automatically to recipe fields with the same name and type. You can change these mappings. In this example, the Currency field will be mapped automatically.
- Appended fields with different names are not mapped automatically, but you can map them to any fields of the same type. In this example, you have to manually map the Value field to the Amount field.
- Fields with different types can’t be mapped.
- Recipe fields that are not in the appended data are added to the appended rows and populated with nulls. In this example, the Lead Source field will be added to the appended rows.
    
    ![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 If null measure handling in datasets isn’t enabled for your org, measure fields are populated with zeros when they’re added to appended rows.

Follow these steps to append data in a recipe.

1. On the recipe page, click the Append Data button (![Append 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_recipe_append_button.png)).
2. Select either the DATASETS or CONNECTED DATA tab, and click the dataset or object that you want to add. In our example, you would select the Opportunity dataset from the CanadaOrg connection.
    
    ![Select dataset to append 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_recipe_append_select.png)
3. On the map fields dialog, review how CRM Analytics has mapped the recipe fields in the first column to fields from the data to append in the second column. Remember, fields with the same name and type are mapped automatically.
    
    ![Map fields 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_recipe_append_map.png)
    
    ![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 By default, hidden fields in your recipe aren’t mapped. To map hidden fields, click the **Show hidden fields** link and accept or change the mappings.
4. To change a field mapping, click the field in the FIELD TO APPEND column, and select a field. You can only select from fields of the same type as the recipe field that you’re mapping to.
    
    In our example, you don’t have a field to map to the Lead Source field, so you leave that as it is. The Amount field has not been mapped because the corresponding field in the Canada data was named Value. So you map the Value field to the Amount field.
    
    ![Mapping the Value field to the Amount field in the recipe](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_recipe_append_map_field.png)
5. When you finish mapping fields, click **Continue**.
6. On the confirmation message, click **Append**.
    
    ![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 Rows that you append in a recipe do not appear in the recipe preview, but are added to the target dataset when you run the recipe.

When you append data, a new step is created in your recipe.

![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_recipe_append_step.png)

When you run the recipe, the rows are appended in the target dataset.

![Table showing result of append](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_recipe_append_result.png)

Here, the Lead Source field has been added to the Canada rows and populated with null values. The Value values from the Canada rows now appear in the Amount column.