I would like to change data type of about 60 columns from integer to double at the same time.
I used Column rename which has the option of changing data type but I have to repeat similar procedure (select and change the type) for each of 60 columns.
I was wondering is there any node that allows to do this action for all columns at once?
Thank you very much for your help
You can use the String Manipulation (Multicolumn) with the following formula toDouble(string($$CURRENTCOLUMN$$))
The rename node is not a good option to change types unfortunately
I would use Math Formula (Multi Column) node. And why changing column type to double? Check this topic for more:
Unfotunately, string manipulation node only works with rows in single column ;/
yeah, this is exactly what I actually wanted to look for.
Thanks a lot for your help
@HanhDo You are right, that’s why the suggested node is the Multicolumn String Manipulation one:
ahhhh, ukie, now I got it. Thank a lots
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.