CSV Parsing Inputs

[amit_saroha]

Hi All,
I have a tab-separated CSV file with let us say 10, 000 records and I am using CSV parser snap to parse the file. The process works fine when there is no data issue but when there is a data issue the whole file fails.

Could you suggest if there is a way to ignore the record with the data issue and process the other records?

[cstewart · Accepted solution]

Does using the error handling (Discard/Route to Error View) not resolve this?

[amit_saroha]

It worked using the error view but how do I report these records?

[darshthakkar]

You can write these records using a file writer or email the concerned person using “Email Sender” snap.

[darshthakkar]

amit.saroha:

The process works fine when there is no data issue but when there is a data issue the whole file fails.

@amit.saroha: Can you please elaborate on the data issue part? Are there Null values, different data type for the data you’re expecting?
What is the source system? Isn’t the source system, a source of truth?