Skip to main content

Append Table

Combines two tables by appending the rows of the second table to the first table.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • First Table - The primary table to which rows will be appended.
  • Second Table - The table whose rows will be appended to the first table.

Options​

  • Output Type - Specifies whether to pass the table by reference or by value. Options are:
    • Pass By Reference
    • Pass By Value

Output​

  • Table - The resulting table with rows from both input tables combined.

How It Works​

The Append Table node combines two tables by appending the rows of the second table to the first table. When executed, the node:

  1. Validates that both input tables are not empty and are valid
  2. Checks if the tables are reference tables and handles them appropriately
  3. Ensures that both tables have the same column structure
  4. Concatenates the rows of both tables
  5. Returns the combined table

Requirements​

  • Two valid input tables
  • Both tables must have identical column structures (same column names and order)

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid first table
  • Empty or invalid second table
  • Mismatched column structures between the two tables
  • Invalid table structure

Usage Notes​

  • The Output Type option can be set to "Pass By Reference" for handling large datasets more efficiently
  • The rows from the second table are appended to the end of the first table
  • Both input tables must have exactly the same columns for the operation to succeed