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?
Does using the error handling (Discard/Route to Error View) not resolve this?
@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?
It worked using the error view but how do I report these records?
You can write these records using a file writer or email the concerned person using “Email Sender” snap.