Time for action – generating a range of dates and inspecting the data as it is being created

In this section, you will generate a rowset with one row by date in a date range.

Tip

As you progress, feel free to preview the data that is being generated even if you're not told to do so. This will help you understand what is going on. Testing each step as you move forward makes it easier to debug and craft a functional transformation.

1. Create a new transformation.
2. From the Input group of steps, drag to the canvas a Generate Rows step.
3. Double-click on the step and fill in the grid as shown in the following screenshot:
   
4. Note that you have to change the default value for the Limit textbox. Close the window.
5. From the Transform category of steps, add a Calculator step, and create a hop that goes from the Generate Rows step to this one.
6. Double-click on the Calculator step and add a field named diff_dates as the difference between end_date and start_date. That is, configure it exactly the same way...