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 have the same metadata. If you get a trap detector warning, please verify that you executed these instructions exactly as explained.

7. Select the Dummy step and do a preview. You will see this:

   

What just happened?

You modified the transformation so that you didn't end up discarding the erroneous rows. In the error stream (the stream after the red dotted...