Convert Type
Converts the data type of a specified column in a 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 table containing the column to convert.
- Column Name - The name of the column whose data type will be converted.
Options
- Type - The target data type for the column. Options are:
- object
- int64
- float64
- 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 specified column's data type converted.
How It Works
The Convert Type node changes the data type of a specified column in a table. When executed, the node:
- Validates that the input table is not empty and is valid
- Checks if the table is a reference table and handles it appropriately
- Validates that the column name is not empty
- Ensures a data type is selected
- Converts the specified column to the selected data type
- Returns the updated table
Requirements
- A valid input table
- A valid column name that exists in the table
- A selected target data type
Error Handling
The node will return specific errors in the following cases:
- Empty or invalid input table
- Empty column name
- No data type selected
- Invalid table structure
- Invalid data in the column that cannot be converted to the target type
Usage Notes
- The Output Type option can be set to "Pass By Reference" for handling large datasets more efficiently
- Ensure that the data in the column is compatible with the target data type
- Converting to numeric types (int64, float64) may fail if the column contains non-numeric data