topic Re: How to Convert string field to Decimal in Talend Studio

How to Convert string field to Decimal

Anonymous — Wed, 31 Jan 2018 10:44:41 GMT

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

Re: How to Convert string field to Decimal

Anonymous — Wed, 31 Jan 2018 13:42:13 GMT

Have you tried

Double.parseDouble(row1.CHG_AMT)

Re: How to Convert string field to Decimal

Anonymous — Wed, 31 Jan 2018 15:11:02 GMT

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..

Re: How to Convert string field to Decimal

Anonymous — Thu, 01 Feb 2018 06:20:15 GMT

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.

Re: How to Convert string field to Decimal

Anonymous — Thu, 01 Feb 2018 06:52:51 GMT

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

Re: How to Convert string field to Decimal

manodwhb — Fri, 02 Feb 2018 11:01:49 GMT

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

Re: How to Convert string field to Decimal

Anonymous — Tue, 06 Feb 2018 07:44:25 GMT

Hello,

Is there any update for your issue?

Best regards

Sabrina

Re: How to Convert string field to Decimal

Anonymous — Mon, 12 Mar 2018 14:42:26 GMT

No I have not got the solution yet. Suppose I have an input value like, 111.04 and I am using this in one subtraction from other field which is decimal(20,2) in Mysql and FLOAT(20,2) in Talend.

I am getting data type issue, and it is not correctly calculated.

So how I can change the data type of field(which has 111.04) from String to Flo

@xdshiwrote:

Hello,

Is there any update for your issue?

Best regards

Sabrina

at conversion?

Regards,

Deepak

Re: How to Convert string field to Decimal

manodwhb — Tue, 13 Mar 2018 05:12:12 GMT

first you replace "," with "." using yourString.replaceAll(",", ".")) ,then you can covert using tConvert or Double.parseDouble() in tmap to convert.

Re: How to Convert string field to Decimal

Anonymous — Tue, 13 Mar 2018 05:33:43 GMT

I don't have , in the string value.

I just have something like below with decimal point.

24.56

32.45

Regards,

Deepak

Re: How to Convert string field to Decimal

manodwhb — Tue, 13 Mar 2018 05:35:42 GMT

ok,then you can use tConvertType or Double.parseDouble() in tmap to convert.

Re: How to Convert string field to Decimal

manodwhb — Tue, 03 Apr 2018 14:18:57 GMT

@Deepak1,did it help you?

Re: How to Convert string field to Decimal

manodwhb — Thu, 19 Apr 2018 06:36:31 GMT

@Deepak1,still do you have issue with this?