Skipping faulty records in tab delimited file

Designing Pipelines
,
#1

Greeting!

Is there a way we can skip faulty records which has special symbols as it fails the whole file while using the CSV parser.
image

The highlighted record is the one which needs to be removed, or any records which has special symbols which are not accepted by CSV parser.

Appreciate all your help!

Thanks,
F.

#2

Hi @fajosa,

Go to CSV Parser’s Views tab and change the default behavior of the snap to “Route Error Data to Error View”, this will discard the record that can’t be processed.
image

2 Likes
#3

Thank you! that works!