Let's modify the transformation so that the starting date depends on a parameter.
Press Ctrl+T to open the transformation settings window.
Add a parameter named
START_DATE
with default value01/12/1999
.Add a Get variables step between the Calculator step and the Filter rows step .
Edit the Get variables step and a new field named
start_date
. Under Variable write${START_DATE}
. As Type selectDate
, and under Format select or typedd/MM/yyyy
.Modify the filter step so the condition is now:
date>=start_date and date<=31/12/2020
.Modify the Select values step to remove the
start_date
field.With the Select values step selected do a preview. You will see this: