DSXchange

Hello,

I am trying to implement a logic within the transformer for an output column in a parallel job. This output column is producing the result like 3.24681234. I would like to see my result as 3.247. Do I use the DecimaltoDecimal function? If so, how would I write it? Is there any other way to achieve this desired result?

Thanks in advance,
Akhila.

Hi Akhila -

You don't need to use a function, just specify the appropriate precision and scale in the metadata of your output link. In your case you will want a scale of 3 for your output decimal column.

John.

Hello,

I understand that the change in the metadata range from 15,7 to 15,3 would work but then if I still need to get the output using some transformation logic or some function, then how would I be able to obtain the same?

Thanks in advance,
Akhila.

This can be achieved by using Substring function.

Akhila-

Based on the example you provided, your value should get rounded at the 3rd place. So, as John said you don't need to use DecimalToDecimal function. Specify the required length and precision. It will automatically round the decimal value.

Akhila: I understand that the change in the metadata range from 15,7 to 15,3 would work but then if I still need to get the output using some transformation logic or some function, then how would I be able to obtain the same?

Why do need a detour if you have a straight and shortest way
Is there any specific reason? - just curious

Mayur: This can be achieved by using Substring function.

Where is the 'Substring' function