topic Re: [resolved] Addition and Subtraction in Talend Studio

[resolved] Addition and Subtraction

Anonymous — Tue, 14 Apr 2015 10:43:55 GMT

Hello
Can someone help me please?
I have some data in 4 columns that I need to perform some calculations on.
ID Col1 Col2 Col3 Col4
1 100 150 8 25
2 200 250 9 35
3 150 175 8 27
What I need to do is this simple ecquation
Col1 + Col2 + (Col3 * Col4)
Is this possible to achieve using tJavaRow? is it easier using an Expression within tMap?
I have tried to do this within tJavaRow creating a variable and assigning the equation to the variable but it doesn't like my '+' and '*'. Can someone tell how to achieve this using Java please?
Thank you
Ricco

Re: [resolved] Addition and Subtraction

Anonymous — Tue, 14 Apr 2015 11:02:05 GMT

use tmap since u could drag & drop row values and sum

Re: [resolved] Addition and Subtraction

Anonymous — Tue, 14 Apr 2015 11:12:24 GMT

Output Schema:

Using tJavaRow

Re: [resolved] Addition and Subtraction

Anonymous — Tue, 14 Apr 2015 11:40:35 GMT

Brilliant
Thank you

Re: [resolved] Addition and Subtraction

Anonymous — Tue, 14 Apr 2015 12:05:13 GMT

Something else I failed to mention.
3 of the columns (1,2 and 4) are all BidDecimals and column 3 is an integer.
Can anyone help me calculate based on this criteria?
Thanks

Re: [resolved] Addition and Subtraction

Anonymous — Tue, 14 Apr 2015 12:23:44 GMT

Its ok, I have cracked it.
I have the following
tMap --> tConvertType --> tJavaRow --> tLog
tmap created the addition column.
tConverType convert column 3 to a bigdecimal
tJavaRow dows the calculation and assigns the result to the column i.e
output_row.Column5 = input_row.col1.add(input_row.col2.add(input_row.col3.multiply(imput_row.col4)));
The result is printed in the tLogRow.
Thanks everyone for your inspiration.

Re: [resolved] Addition and Subtraction

Anonymous — Tue, 14 Apr 2015 12:28:04 GMT

Hi ,
Try with below one without tConvertType:
output_row.Column5 = input_row.col1.add(input_row.col2.add((BigDecimal.valueOf(input_row.col3.multiply))(imput_row.col4)));
Regards,
Kumar

Re: [resolved] Addition and Subtraction

Anonymous — Tue, 14 Apr 2015 12:46:52 GMT

ur Welcome Ricco, if u implement casting in tjavarow, u could reduce that tConvertType Component also.