Pentaho 3.2 Data Integration Beginner's Guide

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:
   
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 ...