Time for action—treating errors that may appear

  1. Open the transformation from the tutorial and save it under a different name.
  2. From the Transform category, drag the Add constants step to the canvas.
  3. Create a hop from the Write to log step to the Add constants step.
  4. Add an Integer constant named diff with value 999, and a String constant named age_of_film with value unknown.
  5. After the Add constants step, add a Select values step and use it to remove the fields err_code and err_desc.
  6. Create a hop from the Select values step to the Sort rows step. Your transformation should look like this:
    Time for action—treating errors that may appearerrors, capturingcaptured errors, fixing


    Note that you are merging two streams. Those streams must have ...

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.