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. To the right of DATE_FROM, write 2004-12-01, and to the right of DATE_TO, write 2004-12-10.

9. Click on OK. The following window appears:

   

What just happened?

You modified the transformation from the previous tutorial so the range of dates is taken...