Error Handling
Handling errors in a transformation
This Lab introduces the Select values step and error handling to find invalid date values.
• Explicit data conversion using the Select values step
• Defining error handling
Configure the following steps:
CSV File Input
Select values
Text File output
In the Select Values step, check the Date format: yyy-MM-dd. This is obviously an incorrect format which, the records are captured in the Text file output - Error.
Preview the Text file output - Error step.
Scroll to the end of the execution pane.
Notice the error fields. These have been configured in the hop.
Double-click on the red cross.
Set the format to: MM/dd/yyyy
Last updated
