Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 7. Validating Data and Handling ... > Time for action - treating errors th...
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:
