Suggestion: File / CSV-Reader: All to string (/int/dec/etc)

[mlauber71]

@Jrole your suggestion is valid. I tried my hand at a workflow that would import a CSV via:

Fixed Width File Reader

read all data as one big column and then split the string and recover the column names. Maybe not the most elegant way. In the thread there are also examples to do this with R:

Stop CSV Reader from column type auto detection

OK here is a way to force KNIME to handle CSV all columns as strings (and maybe convert some of them later. Mainly it relies on the quotes and on the column names that would force the whole column to be read as string: [image] Column names will later be inserted separately.