Pentaho Data Integration Beginner's Guide

Time for action – getting orders in a range of dates by using Kettle variables

In this tutorial, you will do the same as you did in the previous tutorial but another method will be explained.

1. Open the main transformation from the Time for action – getting data about shipped orders section, and save it under a new name.
2. Double-click on the Table input step.
3. Modify the SELECT statement as follows:

   SELECT
     ORDERNUMBER
   , ORDERDATE
   , REQUIREDDATE
   , SHIPPEDDATE
   FROM ORDERS
   WHERE STATUS = 'Shipped'
   AND ORDERDATE BETWEEN '${DATE_FROM}' AND '${DATE_TO}'

4. Check the Replace variables in script? checkbox.
5. Save the transformation.
6. With the Select values step selected, click on the Preview button.
7. Click on Configure.
8. Fill the Variables grid in the dialog setting window. ...