topic Re: how to do math operation with BigDecimal datatype in Talend Studio

how to do math operation with BigDecimal datatype

Anonymous — Thu, 06 Jun 2013 11:31:08 GMT

Hi,
I just wonder, how do i wants to do mathematics operation (add, subtract, multiply, divide etc) with data type bigdecimal. It such a problem when using float or double since the value will be rounded and makes my calculation inaccurate. My source currently having long decimal places almost 20 decimal point.
Plz help me

Regards,
Kal

Re: how to do math operation with BigDecimal datatype

alevy — Fri, 07 Jun 2013 03:16:03 GMT

See http://docs.oracle.com/javase/6/docs/api/java/math/BigDecimal.html.

Re: how to do math operation with BigDecimal datatype

Anonymous — Fri, 07 Jun 2013 07:35:13 GMT

HI
You can use setScale() function for bigdecimal help u for rounding or setting the scale, below is the screen shot
thanks
Anil Kumar Burri

Re: how to do math operation with BigDecimal datatype

Anonymous — Thu, 20 Jun 2013 04:56:28 GMT

Dear All, I am trying to read value of a column from a file. The value is something like this 3425876767642397. Yes such big number. I tried using long with length as 10. The job runs fine but the in the output it gives me some weird number and not the one from input. Pls advice whats the data type to be used for such huge numbers.
Regards
Sanjay

Re: how to do math operation with BigDecimal datatype

Ashok_Panda — Mon, 24 Mar 2014 15:53:34 GMT

Hi All,
I am getting error "The operator + is undefined " in Talent tMap expression editor. Any operation i will do in the expression editor i am facing the same problem.I am using Developer version of Telend 5.4.
Can anybody suggest me what to do ?
Thanks
Ashok

Re: how to do math operation with BigDecimal datatype

Anonymous — Tue, 25 Mar 2014 03:19:44 GMT

Hi All,
I am getting error "The operator + is undefined " in Talent tMap expression editor. Any operation i will do in the expression editor i am facing the same problem.I am using Developer version of Telend 5.4.
Can anybody suggest me what to do ?
Thanks
Ashok

It is a Java compilation error, what's the data type of column? Can you please show us the expression?
Shong

Re: how to do math operation with BigDecimal datatype

Anonymous — Sun, 07 Feb 2016 06:38:13 GMT

hii
I'm trying to perform arithmetic operation on one of my columns. when i compile i'm getting a java compilation error
my column data type is BigDecimal. Someone please help me to solve this.
thankyou

Re: how to do math operation with BigDecimal datatype

Anonymous — Mon, 11 Jul 2016 20:19:56 GMT

hii
I'm trying to perform arithmetic operation on one of my columns. when i compile i'm getting a java compilation error
my column data type is BigDecimal. Someone please help me to solve this.
thankyou

Hi Naveen
Are you able to resolve this issue