---
schema_version: "1"
id: c29f64acded1521dd78f176728f5d3230c45031271e9f2dfcd1fd0f26b8b5ee7
title: Combine Rows from Different Data Sources Using the Append Node
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_append_node.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_append_node.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 6c5bcebb5c609c50952d94999b43fffc071ca2d737c0bf57e79095f19a7c65b4
description: Use an append node to combine rows from multiple input data sources into a single result.
products:
  - Data 360
release: "264"
---
# Combine Rows from Different Data Sources Using the Append Node

Use an append node to combine rows from multiple input data sources into a single result.

1. In a batch data transform that has at least one input node, click the Add Node button (![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.
2. Select **Append**.
3. Select the data to append to the batch data transform.
    
    ![Select the input data and then the corresponding columns to append.](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_data_to_append.png)
    
    1. Select the object that you want to add (1).
    2. Under Selected Fields (2), choose which of the object’s columns (also called fields) to include in the appended data, or click **Name** to select all columns.
    3. Click **Next**.
4. Choose how to map columns.
    
    - To automatically map all columns each time your batch data transform runs, turn on **Map all columns**.
    - To manually map two columns, enter the column name from the appended rows next to its corresponding batch data transform column.
    
    A batch data transform maps all columns from both data objects based on matching column API names. To map columns that don’t have corresponding API names, select **Allow schema merge**.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_note.png)
    
    Note If a column is mapped for one source and not the other, the append node inserts null values for all source rows that the column doesn’t apply to. If a numeric column isn’t mapped to a source and null numeric handling isn’t enabled, the append node inserts zeroes instead of nulls for those source rows.
5. To add a column from the appended rows that doesn’t exist in the batch data transform, click **+** and select the column. Leave the batch data transform column blank.
6. Click **Apply** to add the node to the batch data transform.
7. Click **Save**.

When you run the batch data transform, the append node combines rows from both data objects into the same source data.