topic Round up nullable Double in Talend Studio

Round up nullable Double

SR2210 — Sat, 16 Nov 2024 01:29:34 GMT

Hi All,

I extract my data in type String and I need to store them in database as numeric. The data contains decimal numbers and NULL.

For decimal numbers, I need to round up the values to the nearest integer. For example, 4.3145 will be 4 and for NULL i need it to show as NULL in database.

I tried to use Math.Round() function in tMap as below but it throws an error -

I searched and found out that Math.Round() won't work for a nullable Double 😞

Can anyone suggest a way that i can round up the decimal numbers and also load the NULL values in database?

Re: Round up nullable Double

manodwhb — Fri, 11 Sep 2020 08:26:13 GMT

@Syaheerah Radzi ,check the below link. you need to write tjava

https://www.tutorialspoint.com/java/lang/math_round_double.htm

Thanks,

Manohar

Re: Round up nullable Double

vikramk — Fri, 18 Sep 2020 05:55:12 GMT

Hi SR2210,

You could achieve this even by using tConverttype component, please go through below link:

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/7wzgYBYjU0kmyizKfM_7Gw