Time for action – treating errors that may appear
- Open the transformation from the tutorial and save it under a different name.
- From the Transform category, drag the Add constants step to the canvas.
- Create a hop from the Write to log step to the Add constants step.
- Add an
Integer
constant nameddiff
with value999
, and aString
constant namedage_of_film
with valueunknown
. - After the Add constants step, add a Select values step and use it to remove the fields
err_code
anderr_desc
. - 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 ...
Get Pentaho 3.2 Data Integration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.