Pentaho

 View Only

 How to handle corrupted data in INPUT DATA side (text file input)

M Sampath Vinay Kumar Reddy's profile image
M Sampath Vinay Kumar Reddy posted 09-16-2022 00:40

This is my input data


This is how I configured



This is error while previewing the data


How should I handle these errors and abort the corrupted data and get only good data?

Andrew Cave's profile image
Andrew Cave
Hi Sampath

For simple line errors, you can ignore the errors and check the error lines later as shown.


It looks like you've got some zipped data in there - I you need to unzip it you'll need to change the format from CSV as the line feed is not a good line delimiter.  Probably treat it as a binary file instead