Skip to main content

Add Column

Adds a new column to a table with specified values.

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​

  • Table - The input table to which the column will be added.
  • Column Name - The name of the new column to be added.
  • Values - The values to populate the new column.

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 the new column added.

How It Works​

The Add Column node adds a new column to an existing table with the specified values. When executed, the node:

  1. Validates that the input table is not empty and is valid
  2. Checks if the table is a reference table and handles it appropriately
  3. Validates that the column name is not empty
  4. Adds the new column with the provided values to the table
  5. Returns the updated table

Requirements​

  • A valid input table
  • A non-empty column name
  • Values for the new column

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid input table
  • Empty column name
  • Invalid table structure

Usage Notes​

  • The Output Type option can be set to "Pass By Reference" for handling large datasets more efficiently
  • The new column will be added to the end of the table
  • The values provided should match the number of rows in the table for proper alignment