topic Re: [resolved] Exception in component tAggregateRow (BigDecimal average&sum) in Talend Studio

[resolved] Exception in component tAggregateRow (BigDecimal average&sum)

Anonymous — Sat, 16 Nov 2024 12:42:57 GMT

Hi
search in several forums, but cannot find how to resolve my aggregation bug :
Exception in component tAggregateRow_1_AGGOUT
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)

In the tMap :
- I first transform the Integer columns into BigDecimal (define variables to do that) :
Var.NbrSonnAbouti:
row1.DUREE_SONN_ABOUTI==null?null:new BigDecimal(row1.DUREE_SONN_ABOUTI)
- Then a division is performed on 2 columns in the right editor :
For NBR_SONNERIES_ABOUTI column :
Var.NbrSonnAbouti==null?null:Var.NbrSonnAbouti.divide(new BigDecimal(5),2,BigDecimal.ROUND_CEILING)
Same for NBR_SONNERIES_NON_ABOUTI column

Re: [resolved] Exception in component tAggregateRow (BigDecimal average&sum)

Anonymous — Mon, 29 Aug 2011 12:31:12 GMT

Resolved.
The 'Ignore null values' have to be checked for all the colums in the tAggregate (first, I've checked only the average ones)

Re: [resolved] Exception in component tAggregateRow (BigDecimal average&sum)

Anonymous — Tue, 30 Aug 2011 13:50:58 GMT

Hi,
Thanks for the feedback devkl!
Best,
Pcoffre.

Re: [resolved] Exception in component tAggregateRow (BigDecimal average&sum)

Anonymous — Thu, 03 Jul 2014 09:43:44 GMT

what is the difference between tAggregateRow and tCombinedSQLAggregate can you please explain with example

Re: [resolved] Exception in component tAggregateRow (BigDecimal average&sum)

Anonymous — Thu, 03 Jul 2014 10:26:05 GMT

Hi chandu.jayaprada,
Could you please open a new topic? Your issue is not related to current one.
Best regards
Sabrina

Re: [resolved] Exception in component tAggregateRow (BigDecimal average&sum)

klongid — Fri, 04 May 2018 20:38:49 GMT

Thank you. This helped resolve my issue