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