Merge Tables

Merges all rows from a source table into a target table. Supports append or key-based upsert.

Category: Named Tables & Rules Engine · Group: Tables · Activity name: TableMerge

Example

outputVariable = TableMerge("<targetTable>", "<sourceTable>", upsert=False)

Inputs

Name	Type	Required	Default	Description
Target Table	string	Yes		Name of the table to merge into.
Source Table	string	Yes		Name of the table to merge from.
Upsert Mode	boolean		False	If true, upserts by key columns. If false, appends all rows.

Outputs

Name	Type	Description
outputVariable	json	Stores result (targetTable, totalRows).