Which node should I use for data type changes?

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,

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

2 Likes

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.

:blush:

3 Likes

Hi there,

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

Br,
Ivan

2 Likes

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

2 Likes