Start iteration
Description
The Start Iteration activity enables iteration over incoming data, allowing workflow activities within the loop to execute repeatedly with varying values.
This control activity supports row-wise iteration, file-based iteration, and chunk-wise iteration. Each loop pass receives a different input slice, enabling dynamic data transformations, enrichment, or conditional logic.
Use case:
In a data processing workflow, use Start Iteration to loop over rows of customer records fetched from a CRM system. Each iteration can process one customer — validating, enriching, and updating records individually. When used with Parallel Execution, processing time is drastically reduced.
Input
- Data – Required input in tabular form for row or chunk iterations, or as a list of files for file iteration.
Output
| Output Type | Format | Description | 
|---|---|---|
| Iteration Log | JSON | Logs and context from each iteration | 
Configuration Fields
| Field Name | Description | 
|---|---|
| Operation | Specifies the iteration type: 
 | 
| Iteration Limit | Defines the maximum number of iterations to execute. | 
| Identifier Column | Appends the value from this column to the activity name during execution (used in row/file iteration for better traceability). | 
| Use Row for Replacement | If enabled, values in the configuration of nested activities can be replaced by corresponding row values (for row iteration only). | 
| Chunk Size | Applicable when iterating over chunks of rows. Defines the size of each chunk. | 
| Fail on Empty Input | If enabled, the workflow will terminate when this activity receives no input. | 
| Parallel Execution | When enabled, each iteration is executed in parallel for faster processing (use with caution for stateful operations). | 
Sample Input
Not applicable
Sample Configuration
| Field | Value | 
|---|---|
| operation | Iterate over each row | 
| iterationLimit | 100 | 
| identifierColumn | CustomerID | 
| useRowForReplacement | true | 
| failOnEmptyInput | true | 
| parallelExecution | true | 
Sample Output
| Activity Name | Activity Step | Replaced Values | 
|---|---|---|
| SendEmail_12345 | Step 1 | CustomerName: John Doe | 
| SendEmail_67890 | Step 2 | CustomerName: Jane Smith |