How to convert Varchar to Decimal in Transformer??

[Harikrishna_V]

[anbu]

Use StringToDecimal()

[kris007]

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.

[Harikrishna_V]

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.

[kris007]

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.

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 confusing

[chulett]

As noted, StringToDecimal().