Hi,
This is a basic question; I apologize if it seems trivial.
When I am trying to import my csv files or a tab delimited text file, the file reader or csv reader is reading the entire file as one row, yet I need it to read multiple rows. It seems that the problem is that the last value (binary 0 1) of each row is being combined with the first value of the next row (a string value). Is there a problem with my input/are there features to deal with this?
Thanks for any help!
No problem, please keep asking. It seems that you need to adjust the (column) delimiter right; you might also check the Advanced Settings for additional options, like short line support if necessary. Let me know if this is helpful, otherwise don't hesitate to post a snippet of your data.
Thanks for your help. Unfortunately, neither of these worked. I have tried using tab delimited columns; I've also tried commas with a csv file. I've tried changing column headers and reading row ids, "forcing" the number of columns in the flow variables, using short lines, etc. Here is the last bit of my first row (which are headers) and the first bit of my second row, which begins my data. Everything is tab delimited, and there is a hard return between the rows. knime is merging "metclass" + "Abacavir Sulfate" into one column/cell, instead of beginning a new row with Abacavir Sulfate. I don't have any missing values, though I do have a rather large data set (259 x 143)
Thanks for any help!
PND.MRKT BDDCS.Class Excretion metclass
Abacavir Sulfate 1 Validation 1.2 638.75 455.318 1.40287 1.43026 1184.5 793.
Hi,
The problem was that I wrote a file from R and opened it in Excel before ever opening it in KNIME. This somehow changes the formatting. I had to import it directly from R to solve the issue.
Thanks for your help and suggestion!
“allow short lines” option worked for me, thanks