Control

Components to control the execution flow of the workflow.

Conditional Split

Description The Conditional Split component evaluates an aggregated measure or custom expression from the input data against a logical condition, directing execution into one of two branches: If and Else. This allows workflows to follow different processing paths depending on whether the condition evaluates to true or false.

Inputs

• Source table [Table]

Settings The condition can be defined in two ways:

1. Simple condition – built through the UI:

   • Column: The column from the input table to aggregate.

   • Aggregation method: Function applied to the column (e.g., MIN, MAX, AVG, SUM).

   • Operator: Comparison operator (e.g., Is equal to, Is greater than, Is less than).

   • Value: The value to compare the aggregated result against.

2. Custom expression – a manually written SQL expression that can include multiple columns, functions, and logical operators (e.g., AVG(population) > 3000 AND (category LIKE 'capital_city' OR capital IS TRUE)).

Outputs

• If path [Table]: Passes all rows from the input table when the condition evaluates to TRUE.

• Else path [Table]: Passes all rows from the input table when the condition evaluates to FALSE.

Success/Error Split

Description The Success/Error Split component determines the outcome of the previous component’s execution and routes the workflow accordingly. If the upstream component completes successfully, the workflow continues through the Success branch; if it fails, execution follows the Error branch. This enables workflows to handle errors gracefully, trigger alternative actions, or send notifications when issues occur.

Inputs

• Source table [Table] (only available if the upstream component executed successfully)

Settings

• None

Outputs

• Success path [Table]: Passes the table produced by the previous component if no errors occurred.

• Error path [No table]: Produces no table output (since the previous step failed) but can connect to components such as HTTP Request, Send by Email, or logging for error handling.