DSXchange

Posted: **Fri Sep 25, 2009 8:05 am**

Hi All,

Here i am getting values (Ex: -00005 Or 00009) from source as Decimal (5). If it is -00005 then out put should be 0000A and if it is 00009 then 0000X.

Can any body explain me how to do this...Thanks

Thanks
Chilli

Posted: **Fri Sep 25, 2009 6:23 pm**

chilli wrote:If it is -00005 then out put should be 0000A

Why?

chilli also wrote:and if it is 00009 then 0000X.

Why?
What other possibilities exist?
Please fully document the transformation rule.
Note also that your target data type can not be Decimal.

DSXchange

Convert Decimal to Varchar

Convert Decimal to Varchar

Re: Convert Decimal to Varchar