topic Re: Error converting data type nvarchar to float. in Talend Studio

Error converting data type nvarchar to float.

Anonymous — Wed, 11 Jul 2018 17:32:48 GMT

I am trying to convert a string ( 1223.00) to float in tmap, but it's giving me an error "Error converting datatype nvarchar to float.

I tried the following :

Float.valueOf(row1.field1), still it won't run.

I also tried

row1.field1!= null ? row1.field1.doubleValue() : null

It says "the method doubleValue is undefined for the type String.

Can someone help me with this?

vboppudi — Wed, 11 Jul 2018 18:04:40 GMT

Please try below.

Regards,

iamabhishek — Wed, 11 Jul 2018 18:19:59 GMT

@Gohan - you need to use parseFloat(), valueOf() returns a Float (object) and parseFloat() returns float number.

Code -

Float.parseFloat(row1.field1)

Anonymous — Wed, 11 Jul 2018 18:28:46 GMT