Error Handling
Handling errors in a transformation
Workshop - Error Handling
Finally in this workshop we introduce 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
Create a new Transformation
Any one of these actions opens a new Transformation tab for you to begin designing your transformation.
By clicking File > New > Transformation
By using the CTRL-N hot key
The following content has been automatically generated by an AI system and should be used for informational purposes only. We cannot guarantee the accuracy, completeness, or timeliness of the information provided.
Any actions taken based on this content are at your own risk. We recommend seeking qualified expertise or conducting further research to validate and supplement the information provided.
Select Values
The Select Values step in Pentaho Data Integration (PDI) is a powerful transformation component that allows you to manipulate fields in your data stream. It performs three primary functions:
selecting specific fields to include or exclude
renaming fields, and
converting field data types.
This versatile step enables you to clean and restructure your data by removing unnecessary columns, standardizing field names, or ensuring proper data typing. The Select Values step is commonly used early in transformations to prepare data before more complex operations are performed.
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.
Double-click on the red cross.
Set the format to: MM/dd/yyyy
➡️ Next: Finally RUN the transformation
Last updated
Was this helpful?