Error Handling

Handling errors in a transformation

Workshop - Error Handling

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

Error handling

---

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

1. Select Values

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.

1. 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.

2. Preview the Text file output - Error step.

3. Scroll to the end of the execution pane.

Notice the error fields. These have been configured in the hop.

Error fields

1. Double-click on the red cross.

Error handling - hop

1. Set the format to: MM/dd/yyyy

➡️ Next: Finally RUN the transformation

2. RUN

RUN the Transformation

This final part of the creating a transformation, executed locally.

x

x