topic Re: How to multiply big decimal number with -1 value in Talend Studio

How to multiply big decimal number with -1 value

RAJ6 — Sat, 10 Mar 2018 11:49:56 GMT

Hi talend folks,

How to multiply big decimal number with -1 value.

My column name is data (big decimal).

data column value like (344.0,344.0).

I want to multiply below calculation in tmap.

calculation:

Case when ART = 'R' and SOLL = 'S' then data *- 1
when ART = 'R' and BEN = 'S' then data
else 0

kindly share your information.

Re: How to multiply big decimal number with -1 value

TRF — Sat, 10 Mar 2018 16:52:51 GMT

Hi,

Assuming your data flow is called row71, fields are named as in your question and data datatype is BigDecimal, here is the solution:

(row71.ART == 'R' && row71.SOLL == 'S') ? row71.data.multiply(new BigDecimal(-1)) :
	(row71.ART == 'R' && row71.BEN == 'S') ? row71.data : (new BigDecimal(0))

the tMap with the expression:

and the result for different values:

.---+----+---+----.
|   tLogRow_36    |
|=--+----+---+---=|
|ART|SOLL|BEN|data|
|=--+----+---+---=|
|R  |S   |S  |-100|
|R  |X   |S  |100 |
|R  |X   |X  |0   |
|X  |X   |X  |0   |
'---+----+---+----'

Re: How to multiply big decimal number with -1 value

TRF — Sun, 11 Mar 2018 07:53:55 GMT

Did this help?
If so, thank's to mark your case as solved.

Re: How to multiply big decimal number with -1 value

RAJ6 — Sun, 11 Mar 2018 07:57:30 GMT

Thank you @TRF