Two-column Operation ​

Function Description ​

TIP

Perform addition, subtraction, multiplication, and division on the specified two columns of the data table and save the result to a new column.

Configuration Item Description ​

General ​

Command Input

  • Data Table ObjectTDataTable: You can use the variable returned by the 'Create Data Table' component.

  • Column Name 1 for Operationstring: Specify the column name for the operation.

  • OperatorInteger: Select the operator.

  • Column Name 2 for Operationstring: Specify the column name for the operation.

  • Specified Data TypeInteger: Specify the data type of the calculation result.

  • Result Column Namestring: Specify the name of the new result column.

  • Preview in Data TableBoolean: Preview in Data Table

  • Print Component Output Variable ValueBoolean: When checked, the variable data or value generated by the component will be output and printed to the console output log.

Command Output

  • Post-operation DataTDataTable: Used to store the data table after the operation.

Error Handling ​

  • Print Error LogsBoolean: Whether to print error logs to the "Logs" panel when the command fails. Default is checked.

  • Handling MethodInteger:

    • Terminate Process: If the command fails, terminate the process.

    • Ignore Exception and Continue Execution: If the command fails, ignore the exception and continue the process.

    • Retry This Command: If the command fails, retry the command a specified number of times with a specified interval between retries.

Usage Example ​

Process logic description:

Common Errors and Handling ​

None

Frequently Asked Questions ​

None