topic Re: [resolved] String to Big-Decimal conversion in Talend Studio

[resolved] String to Big-Decimal conversion

Anonymous — Mon, 30 Nov 2015 17:48:18 GMT

Hi All,
I have the situation where I need to convert the String result returned by an if-else block in Talend that I need to convert into bigdecimal. I have tried out the below two options and none of them seem to be working
Option 1:
(BigDecimal) ( Col1="ABC" ? Col2 : Col3)
Option 2:
(new BigDecimal(Col1="ABC" ? Col2:Col3))
In this case both Col2 and Col3 are variables of string datatype in tmap.
Please share your suggestion on whether its possible to get this type of a conversion done.

Re: [resolved] String to Big-Decimal conversion

Anonymous — Mon, 30 Nov 2015 23:52:59 GMT

You are missing your row names from your "Col" names. You are also not checking for equality correctly. Assuming your row names are "row1", your code should look something like below...
new BigDecimal((row1.Col1.compareTo("ABC")==0 ? row1.Col2 : row1.Col3))
The in-line IF is contained inside brackets. This just aids readability.

Re: [resolved] String to Big-Decimal conversion

Anonymous — Tue, 01 Dec 2015 07:11:16 GMT

I've tried using the expression below in the variable port of a tMap:
new BigDecimal((row1.field1.toString() != null ? row1.field1 row1.field2.toString() != null ? row1.field2 : 1)))
But I get Java exception errors while testing the expression. Please note that both field1 and field are of BigDecimal datatype and I need to check if they are null.

Re: [resolved] String to Big-Decimal conversion

Anonymous — Tue, 01 Dec 2015 09:08:34 GMT

If field1 and field2 are BigDecimals, then you don't need to create a new one unless you are creating one for the "1" at the end.
The error you are getting is probably a nullpointerexception because you cannot use methods from a null object. You are trying to use ".toString()". If the object is null, you will get the nullpointerexception.
Why not use.....
row1.field1!=null ? row1.field1 : row1.field2!=null ? row1.field2 : new BigDecimal(1)