View original (French)

Rounding numbers in a TMap in Talend! Very IMPORTANT

Lucie -  
 Lucie -
Hello,
So, I'm creating a program in Talend and in a TMap, I want to round a number so that I don't have 15 digits after the decimal point, but I can't figure it out since it's not like in SQL!
If anyone can help, it would be really nice because my problem is urgent!
Thank you in advance.

1 answer

  1. Lucie
     
    I'm actually looking for an equivalent of this:
    to_number(DECODE(r.FISHING_TIME,null,null,
    ROUND(a.fishing_time/DECODE(r.FISHING_TIME,0,1,r.FISHING_TIME),5))) but the ROUND function is not compatible in a TMAP!
    0