convert string to integer

Solved!
DE_BYTEL
Level 1
convert string to integer

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.

 

Capture.PNG

Do you have an idea ? 

 

 

0 Kudos
1 Solution
AlexT
Dataiker

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

Thanks

View solution in original post

0 Kudos
2 Replies
AlexT
Dataiker

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

Thanks

0 Kudos
DE_BYTEL
Level 1
Author

Hi @AlexT ,

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

0 Kudos