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:
    Time for action – generating a range of dates and inspecting the data as it is being created
  4. Note that you have to change the default ...

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