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.
- Open the transformation from the previous tutorial and save it under a new name.
- From the Input category, add a Get System Info step.
- 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
anddate_to
respectively. Create a hop from the Get System Info step to the Table input step. - Double-click the Table input step.
- Modify the
SELECT
statement as follows:SELECT ORDERNUMBER , ORDERDATE , REQUIREDDATE , SHIPPEDDATE FROM ORDERS WHERE STATUS = 'Shipped' AND ORDERDATE BETWEEN ? AND ?
- In the drop-down list to the right side ...
Get Pentaho 3.2 Data Integration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.