DSXchange

Hi All,

I have a requirement where in I need to set the format for all the values in a column to the following..

Input : 1 1.95 1.2

Output: $1.00 $1.95 $1.2

Append with a $ symbol in the start and append decimal with two zeros

I looked for FMT function which is available in Sequence User Variable stage.


I need to apply this in a transformer.. Can anyone please suggest some ideas..

Regards
Coles

There's nothing like the Fmt() function in the parallel Transformer stage. You could convert the source data using StringToDecimal() or DecimalToDecimal() as appropriate then prepend the result with the string "$".