Skip to main content

Merge Tables

Combines two tables by merging their columns side by side.

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 first table to be merged.
  • Second Table - The second table to be merged.

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 columns from both input tables merged side by side.

How It Works​

The Merge Tables node combines two tables by merging their columns side by side. 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. Converts both tables to pandas DataFrames
  4. Renames columns in the second table if there are naming conflicts
  5. Concatenates the DataFrames horizontally (side by side)
  6. Replaces any NaN values with empty strings
  7. Converts the result back to the data table format
  8. Returns the merged table

Requirements​

  • Two valid input tables
  • Sufficient memory to handle the merged table

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid first table
  • Empty or invalid second table
  • Invalid table structure

Usage Notes​

  • The Output Type option can be set to "Pass By Reference" for handling large tables more efficiently
  • If both tables have columns with the same name, the columns from the second table will be renamed with a "_2" suffix
  • The number of rows in the output table will match the number of rows in the input tables
  • NaN values are automatically converted to empty strings