An Iterate group repeats the series of grouped activities once for every item in an existing sequence or list. The list can be items of any datatype. The loop executes for the number of iterations specified.
This process performs the following operations:
- A JDBC Query activity (CustomerQuery) is used to query a database and populate a list of customer records. The customer records are then passed to a group containing the Log activity.
- The Log activity writes the name and address of each customer to a log and appends to the log as each record is written.
- The group iterates once for every customer record returned by the CustomerQuery activity.
- The process then reads the log that was written for its data to be available to the process, and then transitions to a SendMail activity to send the contents of the customer list through email.
The General tab has the following fields.
A group of shared variables. Depending on the group selected in Group Type, Container displays the group. For example, if the Iterate group is selected in the Group Type field, it displays Iterate in Container. You can add multiple variables of complex or simple type.
You can select from the following available Variable Type options: