I have my job is like:
source columns
A--(double,15)
B--(double,15)
TARGET: C(varchar)
I am populating target C with B and converting in to varchar.
the code using now like: dfloattostringnoexp(col.B,15)
this is working fine.but But now i have a change request like
if columnA='XXX' Then populate target column with B and should haveonly 2 decimal places,else populate B.
How to acheive this without using basic transformer using'FMT'function.
The reason behind this is If i use basic ,i am not able to find the dfloattostringnoexp()function(to convert double to varchar).
Is there any function available in normal transformer stage to populate only with 2 decimal places.
appreciate the help.
two decimal places
Moderators: chulett, rschirm, roy
two decimal places
Thanx&Regards
scorpion
scorpion