Decimaltostring conversion not returning any data

dsguy · Post by **dsguy** » Wed Dec 06, 2006 9:13 am

Hi

When i try to convert from decimal to string using DecimalToString function, the output for that column is returning with null.Please help me in this

I have used the following fuctions in the transformar stage for which i am getting null.

DecimalToString(Link1.CDML_AMT,"suppress_zero")
DecimalToString(Link1.CDML_AMT,"fix_zero")
DecimalToString(Link1.CDML_AMT,"fix_zero,suppress_zero")

Thanks

Nageshsunkoji · Post by **Nageshsunkoji** » Wed Dec 06, 2006 9:54 am

Hi,

Perform This Function :

Trim(DecimalToString(Link1.CDML_AMT,"fix_zero,suppress_zero")) and make sure that your output field will be VARCHAR filed.

Nageshsunkoji · Post by **Nageshsunkoji** » Wed Dec 06, 2006 9:59 am

Further to my previous post, please go through this link, it will give you more useful information about DecimalToString

viewtopic.php?t=92696&highlight=DecimalToString

and do believe in search option always. It is faster than humans.

dsguy · Post by **dsguy** » Wed Dec 06, 2006 10:11 am

Thanks a lot man
I could do get out put now..