read csv operator generate wrong result

Amy11Amy11 Member Posts: 5 Contributor I
edited December 2018 in Help

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

  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 954   Unicorn

    Hi @Amy11,

     

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

     

    Regards,

     

    Lionel

    sgenzer
Sign In or Register to comment.