---
schema_version: "1"
id: e06ea9d309ee8143a955688f26f570ccfdb33a0d55d4727c58485ff9076d97ea
title: "Update Node: Swap Column Values"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_update.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_update.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 52ebe18dc1a018cb169e31987edd4500b477b0b8e074b98fe7f8b9e2d19017b7
description: In CRM Analytics, you can swap column values with data from another data source when key pairs match with the Update node. For example, to update selected account names after a series of recent acquisitions and mergers, replace the name from an uploaded spreadsheet based on matching account IDs. Processing time is minimized by only changing column values with matching key pairs, instead of every value in the column.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Update Node: Swap Column Values

In CRM Analytics, you can swap column values with data from another data source when key pairs match with the Update node. For example, to update selected account names after a series of recent acquisitions and mergers, replace the name from an uploaded spreadsheet based on matching account IDs. Processing time is minimized by only changing column values with matching key pairs, instead of every value in the column.

<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="d45528e38">User Permissions
                Needed</th>
            </tr>
          </thead>
          <tbody>
            <tr class="">
              <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d45528e38 ">To manage and create a recipe:</td>

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

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

1. In a Data Prep recipe that already has at least one Input node, select the Add Node button ![Add Node 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_button_add_node.png) between two nodes or at the end of the recipe. To show the Add Node button between two nodes, hover the cursor on the connecting line.
2. In the Add Node dialog, select **Update**.
    
    ![The Add Node modal shows all possible nodes that you can add, including the Update node.](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_recipe_node_update.png)
3. Choose the data source containing the update data.
    
    ![The update node replacement value selector.](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_recipe_node_update_replace_select.png)
    
    Alternatively, if the original and update data are already added as input nodes, drag the Add Node button (![Add Node 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_button_add_node.png)) from one to the other and click Update. The two inputs are used as the source and update location.
4. Choose which key pair values must match between the original and update data (1).
    
    ![The Update node configuration 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_recipe_node_update_configure.png)
5. Choose the columns to update (2). If all key pairs match for a row, the column value is updated.
6. Click **Apply**. When the recipe runs, the update node contains the original data with updated column values.
7. Save the recipe.