At the beginning of the Validating Data section in this chapter, you learned to validate a field discarding the rows with invalid values. Now you will learn how to avoid discarding the row. You will fix the issue by proposing a product code equal to <invalid>. After doing so, you will send the rows with invalid values back to the main stream:
- Open the Transformation you created in the Validating Data section and save it with a different name.
- After the Write to log step, add a UDJE step. Use the step to replace the invalid product code with the text <invalid> and also to add two strings—a flag to indicate that there is an error and a new field named ERR_DESC with the description of the problem: ...
