Remove Row

Removes a specified row 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 remove a row.
• Row Index - The index of the row to be removed. Use -1 to remove the last row.

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 data table with the specified row removed.

How It Works

The Remove Row node removes a specified row 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 row index is a valid integer
4. Removes the row at the specified index from the table
5. Converts the modified table to a pandas DataFrame
6. Converts the DataFrame back to the data table format
7. Returns the updated table

Requirements

• A valid input data table
• A valid row index (must be an integer)

Error Handling

The node will return specific errors in the following cases:

• Empty or invalid input table
• Invalid row index (not an integer)
• Invalid table structure
• Row index out of range

Usage Notes

• The Output Type option can be set to "Pass By Reference" for handling large tables more efficiently
• Row indices are zero-based (0 for the first row, 1 for the second, etc.)
• Use -1 as the Row Index to remove the last row
• The node permanently removes the specified row from the table
• All data in the removed row is lost