topic [resolved] Round a number in Talend Studio

[resolved] Round a number

_AnonymousUser — Wed, 06 Aug 2014 08:28:28 GMT

Hello,
I read in a tMap an Excel cell who can be "null" or contain a number with delimiter (1 111) and can be décimal (1 111,11...111).
The input format is string, the input format is string.
I try getting the number like that :
9 876 543 --> 9876543 (without separator)
or
1 234 567,55 -> 1234568 (without separator and rounded)
Then I test that :
Relational.ISNULL(row11.newColumn8)?"" tringHandling.CHANGE(row11.newColumn8," ","")
For the separator, it's ok, but I cannot round the number.
Please, help me ...
Thank-you
Quartz92

Re: [resolved] Round a number

Anonymous — Wed, 06 Aug 2014 09:02:39 GMT

In order to round the number, first you will have to change the data type to decimal and then apply round function
Vaibhav

Re: [resolved] Round a number

_AnonymousUser — Wed, 06 Aug 2014 09:33:33 GMT

Thank-you sanvaibhav,
The decimal data type to use is "integer" ?
Then I must do :
Relational.ISNULL(row11.newColumn8)?"":ConvertTypes.String2Int(StringHandling.CHANGE(row11.newColumn8," ",""))
to convert before use round ?
I don't find a round function to use in a tMap.
Do you have more instructions to help me ?
Thank-You !!

Re: [resolved] Round a number

Anonymous — Wed, 06 Aug 2014 09:43:40 GMT

Use java functions inside tMap like below
http://www.tutorialspoint.com/java/number_round.htm or
http://stackoverflow.com/questions/153724/how-to-round-a-number-to-n-decimal-places-in-java

Vaibhav

Re: [resolved] Round a number

_AnonymousUser — Wed, 06 Aug 2014 11:05:39 GMT

Thank-you sanvaibhav,
The two metods you purpose are in Java ... is it possible to do the same thing in a tMap Talend ?

Re: [resolved] Round a number

Anonymous — Wed, 06 Aug 2014 12:07:20 GMT

You can use Java anywhere possible in Talend...
Yes, you can use it tMap as well... Use Ctrl+Space you can get inbuild java functions/routines implemented by talend..
Vaibhav

Re: [resolved] Round a number

_AnonymousUser — Wed, 06 Aug 2014 13:44:51 GMT

Thank-you sanvaibhav !!