Skip to main content

Get Column

Extracts a specific column from a data 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​

  • Table - The input data table from which to extract a column.
  • Column Name - The name of the column to extract.

Options​

This node does not have any options.

Output​

  • Column - The extracted column data as a list of values.

How It Works​

The Get Column node extracts a specific column from a data table. 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. Converts the data table to a pandas DataFrame
  5. Extracts the specified column as a list of values
  6. Returns the column data

Requirements​

  • A valid input data table
  • A valid column name that exists in the table

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid input table
  • Empty column name
  • Invalid table structure
  • Column name does not exist in the table

Usage Notes​

  • The output is a list of values from the specified column
  • The order of values in the output list matches the order of rows in the input table
  • The node works with tables of any size