Pentaho 3.2 Data Integration Beginner's Guide

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:
   

   Note

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