topic Re: Talend BigDecimal division output Weird in Talend Studio

Talend BigDecimal division output Weird

Anonymous — Tue, 23 May 2017 16:19:02 GMT

I have 2 BigDecimal Numbers. I am doing simple division: Number1/Number2.

In talend: tMap: 80/8.52 = 9

but in excel:

9.389671362

The valid answer that I require is the Excel output. What the issue with BigDecimal division in Talend ?

Re: Talend BigDecimal division output Weird

TRF — Tue, 23 May 2017 17:05:51 GMT

Change the scale to 9 and add the rounding mode to the division, like in this example:

row59.num1.divide(row59.num2, 9, BigDecimal.ROUND_HALF_UP)

The result is:

Starting job test at 18:01 23/05/2017.

[statistics] connecting to socket on port 3583
[statistics] connected
.----+----+-----------.
|     tLogRow_26      |
|=---+----+----------=|
|num1|num2|result     |
|=---+----+----------=|
|80.0|8.52|9.389671362|
'----+----+-----------'

[statistics] disconnected
Job test ended at 18:01 23/05/2017. [exit code=0]

Exactly what Excel gives you.

For this example, num1 and num2 are issued from a tFixedFlowInput:

And the result is computed in a tMap:

Hope this helps.

Re: Talend BigDecimal division output Weird

Anonymous — Tue, 23 May 2017 17:36:39 GMT

Thanks a lot for your prompt help !!! It worked.