Changing data type of columns

Hi everyone,

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
Hanh

Hi,

You can use the String Manipulation (Multicolumn) with the following formula toDouble(string($$CURRENTCOLUMN$$))

1 Like

The rename node is not a good option to change types unfortunately

1 Like

Hello @HanhDo,

I would use Math Formula (Multi Column) node. And why changing column type to double? Check this topic for more:

Br,
Ivan

1 Like

Hi,
Thanks @iperez
Unfotunately, string manipulation node only works with rows in single column ;/
Br
Hanh

Hi @ipazin,
yeah, this is exactly what I actually wanted to look for.
Thanks a lot for your help :slight_smile:
Hanh

1 Like

@HanhDo You are right, that’s why the suggested node is the Multicolumn String Manipulation one:
imagen

2 Likes

ahhhh, ukie, now I got it. Thank a lots :slight_smile:
Hanh

1 Like

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