🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

read csv operator generate wrong result

User: "Amy11"
New Altair Community Member
Updated by Jocelyn

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,

 

Find more posts tagged with