Summarize and Calculate by Column ​

Function Description ​

TIP

Perform sum, mean, count, etc., on a specified column of the data table.

Configuration Item Description ​

General ​

Command Input

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

  • Specified Column Namestring: Specify the column name for which to perform the summary calculation; only single-column calculations are supported.

  • Calculation TypeInteger: Select the type of calculation.

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

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

Command Output

  • Calculation ResultDouble: Used to store the calculated result.

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