---
schema_version: "1"
id: cb3f6252140e0644b4a47b9830c93a7666530cf0c023d75352cd8aa770c09581
title: "Update Node: Swap Column Values"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_batch_transform_update.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_update.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: bcce03ed231a022a72064fb2a6bdf5c6ad2c066b68c21b6c9c306893f9becc58
description: 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. To minimize processing time, change column values with matching key pairs instead of every value in the column.
products:
  - Data 360
release: "264"
---
# Update Node: Swap Column Values

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. To minimize processing time, change column values with matching key pairs instead of every value in the column.

1. In a batch data transform that already has at least one input node, select **Add Node** ![Add Node button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_button_add_node.png) between two nodes or at the end of the data transform. 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-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/data_cloud/images/c360_a_batch_transform_update.png)
3. Choose the data source containing the update data. Alternatively, if the original and update data are already added as input nodes, drag **Add Node** (![Add Node button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/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.
5. Choose the columns to update. If all key pairs match for a row, the column value is updated.
6. Click **Apply**. When the batch data transform runs, the update node contains the original data with updated column values.
7. Save the data transform.