DSXchange

Hi!
I'm transforming a Server job to Parallel Job and I have the following command Oconv(Trim(LINK_004.OTHER_AMT),'MD2') that work in a transformer stage and it doesn't work in a parallel job.

I saw that there is a function -> StringtoDecimal(String,Rtype) but the help that I have is very poor.

Can anybody help me?

Additional info -> the input is a string like 112.12 and I need the following output 112.

Regards,

Fernando

fmartinsferreira wrote:Hi!
Additional info -> the input is a string like 112.12 and I need the following output 112.

Try "floor" from the transform functions and that will work for you.

Thanks
Sam

Sorry but I don't understand "floor"

Thanks
Fernando

You can select floor() from the expression editor in the parallel Transformer stage. It's the parallel equivalent of the server Int() function, returning the largest integer smaller than its argument.

Thank you!

Work very well!

Regards,

Fernando