DSXchange

Hi all I am trying to take an input which is defined as decimal and convert it to a string then take a substring of it.

I was trying to do this using the modify stage. I can get the substring to work, but with warnings about not converting it as such:

Implicit conversion from source type "decimal[9,0]"to result type "string"

So I was trying to convert it first and then pass it to the substring function in one specification. Is this possible? or do I need to use a transformer to do this?

Thanks

What function are you using in the Modify stage specification? Data type conversion is not necessarily automatic.

Hi Seanc,

You cannot have 2 orchestrate functions in a single specification. You probably have to use the Transformer in this case.

HTH
--Rich

Indeed, a single Transformer stage is likely to be more efficient than two consecutive Modify stages.

If you are trying to extract some of the digits, why not use arithmetic operations instead?
Conversion from a number to a string is usually less efficient than pure arithmetic processing.

Carter