O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action – avoiding errors while converting the estimated time from string to integer

In this section, you will create a variation of the first transformation in this chapter. In this case, you will allow invalid data as source, but will take care of it:

  1. Create a transformation.
  2. Add a Data Grid step and fill in the Meta tab just like you did in the first section: add a string named project_name and two dates with the format yyyy-MM-dd, named start_date and end_date. Also add a fourth field of type String, named estimated.
  3. Now also fill in the Data tab with the same values you had in that first section. For the estimated field, type the following values: 30, 180, 180, 700, 700, ---.

    Tip

    You can avoid typing all of this in again! Instead of adding ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required