---
schema_version: "1"
id: 1c04822c2879b26564888833f56f341af2217cfb08d19018defe5aa4058d8af1
title: Combine Rows from Different Data Sources by Using the Append Node
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/tua_data_transform_append.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.tua_data_transform_append.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2c3ef9f91006f347c85438355bda932f9a118fffa9ceb221988abe68c1876130
description: Use an append node to combine rows from multiple input data sources into a single result.
products:
  - Tableau Next
release: "264"
---
# Combine Rows from Different Data Sources by 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-analytics-tua-264-0-0-production-enus/d794334f-d174-49d3-a4d2-a615bd2e54aa/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 to append.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-tua-264-0-0-production-enus/d794334f-d174-49d3-a4d2-a615bd2e54aa/tua/images/tua_data_transform_builder_combine_rows.png)
    
    1. Select the object that you want to add, and then select the columns to include.
    2. 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-analytics-tua-264-0-0-production-enus/d794334f-d174-49d3-a4d2-a615bd2e54aa/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 source data objects into the output data.