How to convert object datatype to bigdecimal/double

Anonymous — Sat, 16 Nov 2024 09:32:06 GMT

I am using source as ms sql in talend big data version. There is data type as Money. While fetching schema from db. The data type changed to object. Now I need to convert it to BigDecimal or Double in tmap. I Tried to use new Bigdecimal(column name).But Its not working.

Thanks in advance.

Re: How to convert object datatype to bigdecimal/double

Anonymous — Thu, 13 Jul 2017 02:28:00 GMT

Can you try to set the schema in your MSSQL component to Big Decimal there so that it retrieves it as a big decimal?

If not, then you need to understand what the object contains first. If it is a String, then you can cast the object to a String first like:

new BigDecima((String)columnname)

See the BigDecimal constructors here https://docs.oracle.com/javase/7/docs/api/java/math/BigDecimal.html

There is no constructor for generic Object type. Hence, you will need to know what is in the Object and cast accordingly.

topic Re: How to convert object datatype to bigdecimal/double in Talend Studio

How to convert object datatype to bigdecimal/double

Re: How to convert object datatype to bigdecimal/double