topic Re: [resolved] how can i add many bigdecimal ? in Talend Studio

[resolved] how can i add many bigdecimal ?

Anonymous — Mon, 21 Jul 2014 11:45:32 GMT

i have to do this operation but it returns exception error .
row13.montant.subtract(row20.montant.add(row21.montant).add(row18.montant).add(row17.montant).add(row3.position)
please how can i resolve this problem?
Thank you

Re: [resolved] how can i add many bigdecimal ?

Anonymous — Mon, 21 Jul 2014 16:09:00 GMT

Hi Emy,
What error you are getting? is it null pointer? Check the post
https://community.talend.com/t5/Design-and-Development/resolved-Adding-expressions-to-tMap-component/td-p/105545
Vaibhav

Re: [resolved] how can i add many bigdecimal ?

_AnonymousUser — Mon, 21 Jul 2014 22:25:50 GMT

But i have to sum many values of bigdecimal so more than two values . Ho can i calculate it please

Re: [resolved] how can i add many bigdecimal ?

Anonymous — Mon, 21 Jul 2014 23:35:37 GMT

tAggregateRow will sum them for you.

Re: [resolved] how can i add many bigdecimal ?

Anonymous — Tue, 22 Jul 2014 05:27:25 GMT

Hi emy,
Could you please give us more info about your current job situation. What's your job requirment?
Best regards
Sabrina

Re: [resolved] how can i add many bigdecimal ?

Anonymous — Tue, 22 Jul 2014 09:12:11 GMT

row13.montant.subtract(row20.montant.add(row21.montant).add(row18.montant).add(row17.montant).add(row3.position))
I think you missed last close bracket... check again

Vaibhav

Re: [resolved] how can i add many bigdecimal ?

_AnonymousUser — Tue, 22 Jul 2014 18:38:31 GMT

Yes of course ,
I'm going to show you my job to understand what i mean :
and this is the SQL request :
Ecart = ( Montant4 - ( Position3 + Montant22 + Montant21 + Montant20 + Montant19 + Montant18 ))
and this is it on Talend :
Ecart= row4.Montant.subtract(row3.Position.add(row22.Montant).add(row21.Montant).add(row20.Montant).add(row19.Montant).add(row18.Montant))
But it returns this error :
Exception in component tMap_1
java.lang.NullPointerException
at java.math.BigDecimal.add(Unknown Source)
at myfirstproject.glob2_0_1.glob2.tMysqlInput_1Process(glob2.java:3288)
at myfirstproject.glob2_0_1.glob2.runJobInTOS(glob2.java:18077)
at myfirstproject.glob2_0_1.glob2.main(glob2.java:17942)
i know how to sum 2 bigdecimal but in this case what can i do i have to sum 6 bigdecimal and substract them .
Thanks for ur answer please help me

Re: [resolved] how can i add many bigdecimal ?

_AnonymousUser — Tue, 22 Jul 2014 18:41:06 GMT

Yes of course ,
I'm going to show you my job to understand what i mean :

and this is the SQL request :
Ecart = ( Montant4 - ( Position3 + Montant22 + Montant21 + Montant20 + Montant19 + Montant18 ))
and this is it on Talend :
Ecart=row4.Montant.subtract(row3.Position.add(row22.Montant).add(row21.Montant).add(row20.Montant).add(row19.Montant).add(row18.Montant))
But it returns this error :
Exception in component tMap_1
java.lang.NullPointerException
at java.math.BigDecimal.add(Unknown Source)
at myfirstproject.glob2_0_1.glob2.tMysqlInput_1Process(glob2.java:3288)
at myfirstproject.glob2_0_1.glob2.runJobInTOS(glob2.java:18077)
at myfirstproject.glob2_0_1.glob2.main(glob2.java:17942)
i know how to sum 2 bigdecimal but in this case what can i do i have to sum 6 bigdecimal and substract them .
Thanks for ur answer please help me

Re: [resolved] how can i add many bigdecimal ?

Anonymous — Wed, 23 Jul 2014 09:02:30 GMT

Hi Emy,
You have null pointer exception... it means some of your column contains null value...
You will have to handle null for each column like - check the post - http://www.talendforge.org/forum/viewtopic.php?id=7782
row2.Price2==null?row1.Price1:row1.Price1.add(row2.Price2)
This is going to be a two to three line code if you do it in single tMap... but if you prefer, you can use tJavaRow to make it more simple and add it column wise..
Vaibhav

Re: [resolved] how can i add many bigdecimal ?

Anonymous — Wed, 23 Jul 2014 09:11:42 GMT

hi all,
my question is "is it normal that you have null value" ?
manage null value is a tecnical issue but what's your business rule when application 's encountering null value espacially when you're doing calculation ?
how many null value do you have from sources ?
Could it be null ?
regards
laurent

Re: [resolved] how can i add many bigdecimal ?

_AnonymousUser — Wed, 23 Jul 2014 10:32:59 GMT

sanvaibhav : how can i write this line row2.Price2==null?row1.Price1:row1.Price1.add(row2.Price2) for three or four bigdecimal . it does'nt work !!

kzone : yes all of them can be null .

Re: [resolved] how can i add many bigdecimal ?

_AnonymousUser — Wed, 23 Jul 2014 13:39:09 GMT

thank you alll , i have found a solution

Re: [resolved] how can i add many bigdecimal ?

Anonymous — Wed, 23 Jul 2014 14:18:10 GMT

Emy,
Please let us know your solution... it seems you are very happy...
Vaibhav

Re: [resolved] how can i add many bigdecimal ?

Anonymous — Tue, 25 Sep 2018 15:45:54 GMT

Please, what the solution that did you find ?