DSXchange

While using the following command :
DecimalToString(lReadInput.NRx1,"fix_zero,suppress_zero")

I m getting the following warning:
"Transformer_0,0: Conversion error converting input field NRx1 to output field NRx1, data may have been lost"

My input datatype is decimal(9,3) and output datatype is varchar(9)

Try giving output datatype to varchar(11)

It would be a better learning experience were you to explain why.

ray.wurlod wrote: It would be a better learning experience were you to explain why.

Sure.

9 + 1(Sign) + 1(Decimal Point)= Varchar(11)

Well done.

In words, the string needs nine characters for the nine significant digits (precision of the Decimal data type), plus one for the sign and one for the decimal point character. That's a total of eleven characters. The VarChar needs to be at least this large.

A golden star awaits