title: While loop implementation in Pentaho Kettle
body: <p>I need guidence on implementing WHILE loop with Kettle/PDI. The scenario is</p>
  
  <p>(1) I have some (may be thousand or thousands of thousand) data in a table, to be validated with a remote server. </p>
  
  <p>(2) Read them and loopup to the remote server; I use Modified Java Script for this as remote server lookup validation is defined in external Java JAR file (I can use "Change number of copies to start... option on Modified java script and set to 5 or 10)</p>
  
  <p>(3) Update the result on database table. There will be 50 to 60% connection failure cases each session.</p>
  
  <p>(4) Repeat Step 1 to step 3 till all gets updated to success</p>
  
  <p>(5) Stop looping on Nth cycle; this is to avoid very long or infinite looping, N value may be 5 or 10.</p>
  
  <p>How to design such a WhILE loop in Pentaho Kettle?</p>