Error Handling
Handling errors in a transformation
Last updated
Was this helpful?
Handling errors in a transformation
Last updated
Was this helpful?
This workshop 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