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.
@Mary,can you provide sample date which are you going to String to BigDecimal? I believe there could be data issue.
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...
@Mary,still you have issue,please check the below link.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables