Pentaho Data Integration Beginner's Guide

Iterating jobs and transformations

It may happen that you develop a job or a transformation to be executed several times, one for a different row of your data. Suppose, for example, you have to send a custom email to a list of customers. Then you would build a job that, for a given customer, gets the relevant data as name or e-mail account and send the e-mail. Then you would run the job manually several times, once for each customer. Instead of doing that, PDI allows you to execute the job automatically once for each customer in your list.

The same applies to transformations. If you have to execute the same transformation several times, once for each row of a set of data, you can do it by iterating the execution. The next section shows you how ...