O'Reilly logo

Pentaho 3.2 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—checking films file with the Data Validator

Let's validate not only the Genres field, but also the Year field.

  1. Open the last transformation and save it under a new name.
  2. Delete all steps except the Text file input and Text file output steps.
  3. In the Fields tab of the Text file input step, change the Type of the Year from Integer to String.
  4. From the Validation category add a Data Validator step. Also add a Select values step. Link all steps as follows:
    Time for action—checking films file with the Data Validator
  5. Double-click the Data Validator step.
  6. Check the Report all errors, not only the first option found on at the top of the window. This will enable the Output one row, concatenate errors with ...

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