读csv operator generate wrong result

Amy11Amy11 MemberPosts:5Contributor I
edited December 2018 inHelp

Hello,

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

myinput.csv file has 900 rows

myoutput. csv文件有782行

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, MemberPosts:1,195Unicorn

    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 InorRegisterto comment.