topic Re: Float Datatype in Talend Studio

Float Datatype

SMahadevan1608028474 — Tue, 26 Jan 2021 16:49:08 GMT

I have the source column as Product_Amount as Float Datatype (Eg: 23.6161)

I am expecting this should load only the 2 decimal values (Eg: 23.61).

In Var

******

(int)(Float.parseFloat(row4.Product_Amount)*100) - Datatype is Int

Here I need to cut off the amount and need to multiply by 100 to convert to integer.

In output table

****************

Float.parseFloat(String.valueOf(Var.var9))/100 - Type is Float

While running the program I got the error as attached.

Note: But the same logics is worked while convert from String to Double.

Re: Float Datatype

SMahadevan1608028474 — Wed, 27 Jan 2021 17:21:15 GMT

Can anyone assist is there any issue in my logics?

Re: Float Datatype

Anonymous — Thu, 28 Jan 2021 10:59:19 GMT

Hello,

Did you try to add the precision part of your float column to 2? If your use case is trying to deal with a floating point error, using a BigDecimal instead of a float will better.

Re: Float Datatype

SMahadevan1608028474 — Thu, 28 Jan 2021 11:45:04 GMT

I have tried with state but am getting the same error , even I have changed to Precision "2"

In Var

******

(int)(Float.parseFloat(row4.Product_Amount)*100) - Datatype is Int

In output table

****************

Float.parseFloat(String.valueOf(Var.var9))/100 - Type is Float and Precision as "2".

Even I have tried with BigDecimal as well.

Re: Float Datatype

SMahadevan1608028474 — Thu, 04 Feb 2021 15:25:18 GMT

Hi,

Is anyone can assist this issue.