Which node should I use for data type changes?

[sbrasfield]

Hello,
Which node is used similarly to Alteryx’s Select which would allow me to define data types?
I have an Excel file I’ve bringing in via Excel Reader, and I think I need to filter this through a node to force column data types, but I can’t find what I’m looking for. Any help would be greatly appreciated!
Thank you,

[bentheknimeuser]

String to Number
Number to String
Int to Double
String to DateTime
Column Rename

[armingrudd]

In addition to @bentheknimeuser, You may find Column Auto Type Cast node useful in this case. This node cast the best column type for all columns at once automatically.

[ipazin]

Hi there,

Although it is possible I don’t recommend using Column Rename node!

Br,
Ivan

[mlauber71]

Indeed it is not recommended to use that Column rename node. We had some complicated discussions about this:

KNIME nodes corrupting on multiple computers

OK I have a theory of what is going on with the rename node and the changed column types. It seems the rename node stores the information of which type it should assign to a column based on the originating type of the column in question. An integer would have other possibilities to be turned into than a Double. [image] [image] The corresponding numbers are now stored in an XML file “settings.xml” If I would now rename the integer into double and the Double into Fuzzy like this [image] T…