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

Now you will modify your transformation so 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 on it and use the step to get the command line argument 1 and command line argument 2 values. Name the fields date_from and date_to respectively. Create a hop from the Get System Info step to the Table input step.

4. Double-click on 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 of the Insert data from step, select Get System Info as the incoming step.

7. Click on OK.

8. With the Select values step selected, click on the Preview button.

9. Click on Configure.

10. Fill the Arguments grid. To the right of the argument 01, write 2004-12-01. To the right...