topic Convert String to BigDecimal in tMapJoin in Talend Studio

Convert String to BigDecimal in tMapJoin

Anonymous — Mon, 10 Sep 2018 12:25:10 GMT

Hi, in my tMap I'm joining two tables, but I've discovered that the join fields are one a String and one a BigDecimal. The output must be a String. I used the method "toString()" on the BigDecimal field, but it keeps telling me that it cannot convert from String to BigDecimal, which I don't understand since I'm doing the opposite operation.

Re: Convert String to BigDecimal in tMapJoin

manodwhb — Mon, 10 Sep 2018 12:35:41 GMT

@Mary,can you provide sample date which are you going to String to BigDecimal? I believe there could be data issue.

Re: Convert String to BigDecimal in tMapJoin

iamabhishek — Mon, 10 Sep 2018 12:43:46 GMT

Try something like this -

String.valueOf((row1.bigDecimalField).doubleValue())

Re: Convert String to BigDecimal in tMapJoin

Jesperrekuh — Mon, 10 Sep 2018 12:54:15 GMT

could you provide a tMap screenshot please?

- And why to String???
- And if your output is towards a table and its "Create if not exists" setting , when you altered your tMap there's still a problem your table still is BigDecimal ...

However.... an important sidenote :

BigDecimal bgd = new BigDecimal(8.0001)
System.out.println(bgd.toString());
// the output could be : 8.0000999999999998765981265985983427124042342

It will get the closest value So your join goes wrong, instead of the above code, this should be used:

BigDecimal bgd = new BigDecimal.valueOf(8.0001)

I hope Talend conversion works in this way...

Re: Convert String to BigDecimal in tMapJoin

manodwhb — Tue, 11 Sep 2018 09:00:24 GMT

@Mary,still you have issue,please check the below link.

https://community.talend.com/t5/Design-and-Development/String-to-BigDecimal-conversion-issue/m-p/130106#M81285