Time for action—getting orders in a range of dates by using parameters

Now you will modify your transformation so that it shows orders in a range of dates.

  1. Open the transformation from the previous tutorial and save it under a new name.
  2. From the Input category, add a Get System Info step.
  3. Double-click it and use the step to get the command line argument 1 and command line argument 2 values. Name the fields as date_from and date_to respectively. Create a hop from the Get System Info step to the Table input step.
  4. Double-click the Table input step.
  5. Modify the SELECT statement as follows:
    SELECT
    ORDERNUMBER
    , ORDERDATE
    , REQUIREDDATE
    , SHIPPEDDATE
    FROM ORDERS
    WHERE STATUS = 'Shipped'
    AND ORDERDATE BETWEEN ? AND ?
    
  6. In the drop-down list to the right side ...

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.