Different ways of implementing loop in PDI
We come across certain scenarios where in running of the Job/Transformation in loop becomes necessary in Pentaho. Below are the different ways of implementing the loop to the Job in PDI.
1. Using Execute for every input row
Build a job, and let the first transformation retrieve all the rows via Table Input. Use a “Copy rows to result” step to save the result. Create a second transformation configured for single row execution – refer the image advanced transformation settings. Use “Get rows from result” to start single row processing.
2. Use simple evaluation step
Get the number of count for the loop
Assign the count to a variable.
Call the variable in the simple evaluation step( as shown in the figure below)
Give the appropriate condition according to the requirement.
Connect the hop to the job which has to run in a loop.
Best Open Source Business Intelligence Software Helical Insight is Here