The easiest way to loop over a set of values, rows, files, … is to use an Executor transform.
-
Pipeline Executor : run a pipeline for each input row
-
Workflow Executor : run a workflow for each input row
-
Repeat: run a workflow or pipeline from a workflow action until a variable (value) is set.
-
End Repeat: break out of a loop that was started by a Repeat action.
Each of these options allows you to map field values to parameters for the child pipeline or workflow, making loops a breeze.
| Avoid the "old" way of looping in workflows through the Copy rows to result transform. This mostly still exists for historical reasons. It makes it hard to see what is going on inside your loop, and this way of looping won’t be around in Apache Hop forever. |
The Looping how-to guide provides more detailed information on the topic.