columns get mixed up when creating bar chart or group by

[mlauber71]

Are you able to share the data and the workflow? If you are we might take a look. These things come to mind:

• i would recommend doing a group by on the columns in question to see if they really do not contain the unwanted data (if they do the problem is with the import)
• you mentioned you had to use “short line” to import the data. CSV files can be tricky i a separating character also appears in the data itself. KNIME sometimes is seemingly not so great in handling that.
• from the screenshot there seem to be quotes and maybe even cascaded quotes in your data, this could easily mess up the columns on import
• you could try doing the import with the R package Readr *1) or you could try the File Reader of KNIME instead of the CSV reader *2) - they give you more control about how to import data
• if you can get the data via a more stable format then CSV you might want to use that

*1)

Error with File Reader node while running in a loop

I had a similar problem where there were some ‘dirty’ CSV files out of a large number of files and they were too large to just ‘edit’ them in Notepad++ (and that also was not a very nice process). I built a workflow using the R package readr, which seems to me more tolerant towards problematic CSV files and gives you some control how to handle mismatching quotes and so on. You might have to toy around with the settings of the read_delim function. [46] kn_example_import_csv_r_readr.knwf (52.…

*2) KNIME Learning Center | KNIME