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?
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.