topic Re: BigDecimal to integer conversion in Talend Studio

BigDecimal to integer conversion

_AnonymousUser — Sat, 16 Nov 2024 11:42:26 GMT

Hi,
I'm super new to Talend and am running into a problem while extracting data from an oracle database and loading it into a postgres db. I have a few columns that have use the oracle bigDecimal datatype without a precision. To me that meant that its a just a large integer (double) - the postgres db has the equivalent column using an integer datatype. When I try to directly move data through tMap I get an bigDecimal to integer conversion error.
In Java, I know we would use bigDecimalVar.intValue() to convert the bigDecimal into an integer. How do I implement this in tMap? I tried using the bigDecimalColumn.intValue() in the expression box but I get a Java lang error.
Help!
Thanks!

Re: BigDecimal to integer conversion

_AnonymousUser — Tue, 25 Mar 2014 17:44:58 GMT

This is the expression I'm trying to use:
row1.DS_PRS_ID.intValue()

Re: BigDecimal to integer conversion

Anonymous — Tue, 25 Mar 2014 20:42:12 GMT

If you get an Java compilation error this way than at first I would check if I get REAL a BigDecimal as object type.
Could you provide the error message?

Re: BigDecimal to integer conversion

Anonymous — Fri, 17 Apr 2015 12:51:43 GMT

hello all,
i want to convert BigDecimal to integer ,
I am using Integer.parseInt(row.columnname)
but its not working........
please provide solution for this.

Re: BigDecimal to integer conversion

Anonymous — Fri, 17 Apr 2015 12:56:04 GMT

Hi indra,
intValue() convert the big decimal to integer
row3.test.intValue()
Regards,
kumar

Re: BigDecimal to integer conversion

_AnonymousUser — Wed, 14 Dec 2016 04:12:23 GMT

hello all,
i want to convert BigDecimal to integer ,
I am using Integer.parseInt(row.columnname)
but its not working........
please provide solution for this.

Re: BigDecimal to integer conversion

Anonymous — Wed, 14 Dec 2016 09:47:02 GMT

Hi prudvi,
Have you tried to use
row1.newColumn.intValue() //The type of newColumn is BigDecimal.
Best regards
Sabrina

Re: BigDecimal to integer conversion

Eva_Hamel — Thu, 17 Feb 2022 16:48:31 GMT

Hello,

This topic is quite old but I will answer it because people (like me) may look for an answer and find this topic.

Here is the solution I found : you can make a routine such as :

public static Integer Integer(BigDecimal bd) {

return bd.intValue();

}

Then you can call this routine in Tmap or anywhere you need to convert Bigdecimal to Integer by typing {Routine_Name}.Integer({BigDecimal_Value})

Make sure the BigDecimal number you want to convert is convertible to Integer tho.

I'm quite new on Talend so maybe there is a better solution, but Routine is a very powerful tool that can solve many problems.

Cheers