Time for action—getting variables for setting the default starting date

Let's modify the transformation so that the starting date depends on a parameter.

  1. Press Ctrl+T to open the transformation settings window.
  2. Add a parameter named START_DATE with default value 01/12/1999.
  3. Add a Get variables step between the Calculator step and the Filter rows step .
  4. Edit the Get variables step and a new field named start_date. Under Variable write ${START_DATE}. As Type select Date, and under Format select or type dd/MM/yyyy.
  5. Modify the filter step so the condition is now: date>=start_date and date<=31/12/2020.
  6. Modify the Select values step to remove the start_date field.
  7. With the Select values step selected do a preview. You will see this:

What just happened?

You ...

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.