Convert String to BigDecimal in tMapJoin

[Anonymous]

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.

[manodwhb]

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

[iamabhishek]

Try something like this - 

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

[Jesperrekuh]

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...

[manodwhb]

@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/130...