Im trying to import a .csv file using “file reader node”, My sample data is as below,
After i import this data using file reader node, the out put rows are getting shifted to the right because of the “,” with in the cell. Below is the output screenshot of the file reader node:
Settings on file reader node :
1)Column delimiter is set to “,”
2)Advanced> ticked Quoted strings can extend over multiple lines and ticked allow short lines
Is there any other settings to read the data correctly ?
You have a weird consistency in line 23-29 that’s confusing KNIME - there’s an unclosed quote with a line break in between. When I remove those lines everything parses OK, so I’m guessing there’s a bit more cleanup you need to do first?
Actually these are system generated reports and i have about 10 .csv reports , i want to combine them all.
Im trying to build a workflow as below :
As you correctly said these random lines are visible when opened on notpad and not visible on excel,
could you advice as to how to handle this situation on knime?