Six Stars

How to Convert string field to Decimal

Hi Folks,

 

I want to do some sum operation on the  field called CHG_AMT. 

 

I am executing below logic,

row1.CHG_CLASS == "OCC" &&
(row1.CHG_DESC_1 == "Late Payment Charge" ||
row1.CHG_DESC_1 == "Late Charge on Past Due Balances" ||
row1.CHG_DESC_1 == "Late Fee" ||
row1.CHG_DESC_1 == "Finance Charge" ||
row1.CHG_DESC_1 == "Late Payment Interest" ||
row1.CHG_DESC_1 == "Late payment charge on unpaid balance") ?
sum(row1.CHG_AMT) : 0

 

The error I am facing is with data type of CHG_AMT in  the input.

 

So how do I convert this to Decimal and do Sum operation?

 

Any help is appreciated.

 

Thanks

Deepak

Tags (1)
6 REPLIES
Seven Stars

Re: How to Convert string field to Decimal

Have you tried 

Double.parseDouble(row1.CHG_AMT)
Employee

Re: How to Convert string field to Decimal

What is the data type of AMT field coming as input & whats the data type of derived field? Based on that we can advice you conversion..

Six Stars

Re: How to Convert string field to Decimal

Input field is something like 23.34 which is of string type and need to convert that amount field suppose in the second line item will be 34.23. So I have to sum it up and show as amount field.

Moderator

Re: How to Convert string field to Decimal

Hello,

Have you already tried to use Double.parseDouble(name_of_your_input_field) or

new BigDecimal(name_of_your_input_field).doubleValue()

in tMap expression?

tAggregateRow component provides the aggregation key and the relevant result of set operations (min, max, sum...).

For a description of tAggregateRow, please check the documentation user guide.

TalendHelpCenter:tAggregateRow

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Nine Stars

Re: How to Convert string field to Decimal

use Double.parseDouble(sum(row1.CHG_AMT))

Manohar B
Moderator

Re: How to Convert string field to Decimal

Hello,

Is there any update for your issue?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.