Reading Csv - Want to change type of column

Why dont have how change column type when read a csv?

I think that is very important when ppl try to read a csv. When a csv have header, why not we inform a specific column to have a our desire type?

My problem: I am reading a lot of csv, but have a colunm that have a ID like “01234”, the reader use this column as Int/Long and I lost the initial “0”, but to me this is a very important information to lose.
(example: if ID starts with “00”, I lost information)


If you use the File Reader node, you’ll be able to dictate the column types.


But File Reader have a lot of things missing, like read files in folder.
My opinion is, why not have a way that us can force to use string in a colunm that we want? This is very important and basic.

1 Like

Hello @pjosepetti,

just heard on KNIME webinar that this feature is on road map.



That is a great news. Knime is a fantastic tool, but this detail, in my opinion, is very critical and important.

Thx Ivan.


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.