Fixed Iterator
The Fixed Iterator component lets you loop over values of a simple sequence.
This component implements a simple loop over rows of fixed data values. It enables you to run an attached component multiple times, each time with different values set on any number of variables. Those variable can be referenced from the attached component.
To attach the iterator to another component, use the connection ring beneath the Fixed Iterator to connect to the input of the other component. The two components will automatically "snap" together, with the Fixed Iterator sitting on top of the other component, and can be dragged around the canvas as a single component. For more information about stacking and detaching iterators, read Stacking and detaching iterators.
If you need to iterate more than one component, put them into a separate orchestration pipeline or transformation pipeline and use a Run Transformation or Run Orchestration component attached to the iterator. In this way, you can run an entire pipeline flow multiple times, once for each row of variable values.
All iterator components are limited to a maximum 5000 iterations.
Properties
Name = string
A human-readable name for the component.
Concurrency = drop-down
- Concurrent: Iterations are run concurrently.
- Sequential: Iterations are run in sequence, waiting for each to complete before starting the next. This is the default setting.
Full SaaS deployments are limited to 20 concurrent tasks, with additional tasks being queued. Hybrid SaaS deployments with customer-hosted agents have 20 concurrent tasks per agent instance, with a maximum of 100 instances if configured accordingly.
Variables to Iterate = dual listbox
Select the variables that will be iterated. Move a variable from the left column to the right column to select it. Any number of variables can be iterated.
Iterations Values = column editor
Opens the Iteration Values dialog, which has one column for each variable selected in the Variables to Iterate property.
For each variable, add as many values as required, one per row. For example, if you have a text variable "City" with three values "London", "Paris" and "New York", the Fixed Iterator will run the attached component three times, once with the "City" variable set to "London", again with it set to "Paris", and finally with it set to New York".
Break on Failure = drop-down
- No: Attempt to run the attached component for each iteration, regardless of success or failure. This is the default setting.
- Yes: If the attached component does not run successfully, fail immediately.
If a failure occurs during any iteration, the failure link is followed. This parameter controls whether it is followed immediately or after all iterations have been attempted.
This property is only available when Concurrency is set to Sequential. When set to Concurrent, all iterations will be attempted.
| Snowflake | Databricks | Amazon Redshift |
|---|---|---|
| ✅ | ✅ | ✅ |