How to convert Varchar to Decimal in Transformer??
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Sat Mar 13, 2010 11:44 am
- Location: Bangalore
How to convert Varchar to Decimal in Transformer??
Thanks,
Harikrishna.V,Bangalore.
Harikrishna.V,Bangalore.
-
- Participant
- Posts: 6
- Joined: Sat Mar 13, 2010 11:44 am
- Location: Bangalore
kris007 wrote:You can just define the datatype on the output link as Decimal and most of the times that should be enough. If not you can always use StringToDecimal.
Hi,
But I am not sure whether StringToDecimal function will work or not.
We need to use another function i guess.
As you say, changing the data type on output link has worked.
If we have any specific function it would be great.
Thanks,
Harikrishna.V,Bangalore.
Harikrishna.V,Bangalore.
Well..For a start you can start using it and test it to see if it is working. And yes it does work and why would you need another function when you already have one. And how come you marked the topic as resolved? That's confusingHarikrishna_V wrote:But I am not sure whether StringToDecimal function will work or not.We need to use another function i guess.
As you say, changing the data type on output link has worked.
If we have any specific function it would be great.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson