convert string to integer

DE_BYTEL · October 2023

For calculate a sum of my metric, I want to convert a column with string type to integer.

I try the formula in a prepare recipe : numval() but It doesn't works.

Do you have an idea ?

Alexandru · October 2023

Hi @DE_BYTEL
,
Can you try to first replace , with . in that column and then perform the current steps?

Thanks

DE_BYTEL · October 2023

Thank you, I try to replace "," by "." and It works, my column is on integer type.

Best Answer