Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Double Precision

hi,

I have a data "-3024.00"
,"300.22",
,30.44" chracter varying data how to change "double precision" using convert_type??

i was tried give size and precision but got a error!!!

Thanks
Ganesh

1 Community Answers

Matillion Agent  

Kalyan Arangam —

H iGanesh,

Please try using a Calculator component with the following expression – cast( “TextColumnName” as double precision).

I will investigate the issue with Convert Type.

Best
Kalyan

Post Your Community Answer

To add an answer please login