DSXchange

I've searched this and cannot find anything that works for this simple issue.

Input data 4.000, 4.100, 4.120, and 4.123
Target Data 4, 4.1, 4.12 and 4.123

I simply need to retain the trailing zero's. I've tried FMT and playing with with the scale but no luck thus far.

You'd need to target a Char or Varchar field in order to preserve the trailing zeroes.