Forum Discussion

amit_saroha's avatar
amit_saroha
New Contributor III
4 years ago
Solved

CSV Parsing Inputs

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's avatar
    cstewart
    4 years ago

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

4 Replies

  • cstewart's avatar
    cstewart
    Former Employee
    4 years ago

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

    • amit_saroha's avatar
      amit_saroha
      New Contributor III
      4 years ago

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

      • darshthakkar's avatar
        darshthakkar
        Valued Contributor
        4 years ago

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

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago

    @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?