Error Handling
Handling errors in a transformation ..
Workshop - Error Handling
Bad data happens. Don’t fail the whole transformation because of a few rows. Route error rows to a separate stream for review and cleanup.
What you’ll do
Read a CSV with a date field
Trigger a controlled date parsing error
Configure an error hop to capture failing rows
Review the error metadata fields (description, field name, error code)
Fix the date format and verify success
Prerequisites: Complete the Hello World and Logging workshops
Estimated time: 10 minutes
Workshop files
Download the following files.
Keep the filenames unchanged.
Save them in your workshop folder.
Create a new transformation
Use any of these options to open a new transformation tab:
Select File > New > Transformation
Use
Ctrl+N(Windows/Linux) orCmd+N(macOS)
CSV file input
The CSV File Input step reads data from delimited text files into a PDI transformation. While this step is called CSV File Input, you can also use CSV File Input with many other separator types, such as pipes, tabs, and semicolons.
Note: The semicolon (;) is set as the default separator type for this step.
Double-click to edit the CSV file input step.
Set the following metadata properties for: birthdate
birthdate
date
yyyy/MM/dd
If your CSV uses a different date pattern, keep yyyy/MM/dd for now. This mismatch is what triggers the error rows in the next step.
Error hop
An error hop routes rows that fail in a step to a separate target step. This lets you keep processing valid rows. You also get extra error fields in the error stream.
Double-click the white diagonal cross on the red error hop.
Set the error field names (you can pick your own).
Nr of errors fieldname: Number of errors for the row.
Error descriptions fieldname: Human-readable error message.
Error field fieldname: The field that caused the error.
Error codes fieldname: A code you can filter or group by.
Run the transformation
Preview both streams. One contains valid rows. One contains error rows plus error metadata.
Select Run in the canvas toolbar.
Preview the Dummy step:
Preview the Dummy - Errors step:
Scroll to the end of the Execution results pane.
Use errorCodes to route errors into targeted cleanup logic.
Fix the format and verify
Open CSV file input again.
Update the Format value for
birthdateto match your CSV.
Example: if your data looks like 2026-02-17, use yyyy-MM-dd.
Run the transformation again.
Preview Dummy - Errors. You should see fewer rows, or none.
Last updated
Was this helpful?