DecimalTochar Conversion
Posted: Mon Oct 16, 2006 10:48 pm
Hi all
I am using the transformer stage for converting decimal[9] to char[9].
i used the char(%number%) function but it does not provide any solution(also no warning or error msg. is their
in log ) Then i used decimalTosting() function but this also does not provide me the solution..in fact it gives me the warning...
APT_CombinedOperatorController,0: Conversion error calling conversion routine string_from_decimal data may have been lost
i also tried to used Modify stage.. it provide me the sol. but the output contains dots(i.e 037025735.) thus i am not able to use this data in join stage as the other dataset contains (037025735 data in char(9) format)thus join does not provide necessary result.......
Kindly Help me to resolve this issuse...
Thanks in advance...
![Smile :)](./images/smilies/icon_smile.gif)
I am using the transformer stage for converting decimal[9] to char[9].
i used the char(%number%) function but it does not provide any solution(also no warning or error msg. is their
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
![Idea :idea:](./images/smilies/icon_idea.gif)
Kindly Help me to resolve this issuse...
Thanks in advance...