Pentaho 3.2 Data Integration Beginner's Guide

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

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

1. Open the main transformation we created in the Time for action–getting data about shipped orders section and save it under a new name.
2. Double-click 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. Tick the Replace variables in script? checkbox.
5. Save the transformation.
6. With the Select values step selected, click the Preview button.
7. Click on Configure.
8. Fill the Variables grid in the settings dialog window—type ...