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 ...

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.