read csv operator generate wrong result

Amy11
Amy11 New Altair Community Member
edited November 5 in Community Q&A

Hello,

I build a process where I extract my data from .csv file however, the generated result is wrong

 

my input .csv file has 900 rows

my output .csv file has 782 rows

 

when I compared the 2 files I figured out the issue:

  • some rows in my input file are multi line so in the result it was splited into many lines (not what I wish)
  • some rows in my input file starts with " and they were not included (not what I wish)

How to solve this issue so that the input and output have the same # of rows

 

Thank you,

 

Tagged:

Answers

  • lionelderkrikor
    lionelderkrikor New Altair Community Member

    Hi @Amy11,

     

    The best is to share your input .csv file and your process in order we better understand your problem.

     

    Regards,

     

    Lionel