Time for action validating genres with a Regex Evaluation step

In this tutorial you will read the modified films file and validate the genres field.

  1. Create a new transformation.
  2. Read the modified films file just as you did in the previous tutorial.
  3. In the Content tab, check the Rownum in output? option and fill the Rownum fieldname with the text rownum.
  4. Do a preview. You should see this:
    Time for action validating genres with a Regex Evaluation stepunexpected errors, avoidingdata, validating
  5. After the Text file input step, add a Regex Evaluation step. You will find it under the Scripting category of steps.
  6. Under the Step settings box, select Genres as the Field to evaluate, and type genres_ok as the Result Fieldname.
  7. In the Regular expression textbox type ...

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.