topic Re: Round value to two decimal place in Talend Studio

Round value to two decimal place

RA6 — Sat, 16 Nov 2024 08:23:17 GMT

Hello,

I have the following query which update a column :

UPDATE TABLE1 SET COLUMN1= CAST(COLUMN2 AS DECIMAL(15,2)) - CAST(COLUMN3 AS DECIMAL(15,2));

I want to apply the same thing in my tmap.

For info, column2 and column3 is of type string in my file.

COLUMN2	COLUMN3	EXPECTED RESULT
171	0	171.00
0	16 136.07	-16136.07
0	14 718.00	-14 718.00
0	296.61	-296.61
0	1 430.76	-1 430.76
46 040.94	0	46 040.94

Can you advice please?

Thank you in advance.

Best regards,

asadasing

Re: Round value to two decimal place

TRF — Wed, 18 Apr 2018 14:20:19 GMT

As column2 and column3 are Strings, you need to convert to Double before the operation, giving something like:

Double.parseDouble(row1.column2) - Double.parseDouble(row1.column3)

But, as you want 2 digits on the decimal part, you need to convert the result to String:

String.format("%.2f", (Double.parseDouble(row1.column2) - Double.parseDouble(row1.column3)))

Let me know if it works as expected.

Re: Round value to two decimal place

manodwhb — Wed, 18 Apr 2018 14:22:44 GMT

@asadasing,can you try with Math.round() ?

Re: Round value to two decimal place

RA6 — Wed, 18 Apr 2018 14:44:02 GMT

Hello TRF,

Thank you for your quick reasponse.
I checked in notepad++, It works but not in excel.

I guess in the next processing it will consider the decimals.

Best regards,
asadasing

Re: Round value to two decimal place

TRF — Wed, 18 Apr 2018 14:51:40 GMT

OK.

Don't forget to mark your case as solved.

Re: Round value to two decimal place

RA6 — Wed, 02 May 2018 15:26:48 GMT

Hello,

I have applied your solution and encountering some issue.

See url please : https://community.talend.com/t5/Design-and-Development/Format-value-to-two-decimal-places-without-rounding/m-p/118453#M74868

Thank you.
Regards,
Asadasing

Re: Round value to two decimal place

Anonymous — Mon, 06 May 2019 03:26:27 GMT

Hi,

what if i want to convert the values of float which is a string to an integer value.

Ex: My value is a string - 1.00000000, and i want to convert into Integer as 1.

I am trying the below expression, but not able to achieve the requirement.

Integer.parseInt(Double.parseDouble(row16.stringvalue)).IntValue() .

First converting the string to double and then converting to Integer.

Please suggest a solution, Thanks