Originally posted by: SystemAdmin

Hi

I am facing issue with UNZONE function

My Input value is "123N" and the Output should be "-1235"
So i have taken the input field as Number Zoned and Sign Yes and Output i have taken as Number Integer and sign Yes

And in the output field mapping rule i mapped like
="UNZONE(Input Field)"

But its returing the output like 1235 its not returing the output with signed symbol

Any one please let me know how can i get the exact output
Thanks
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: gspvish

Pl upload the map (PI zip)
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Hi,

Take ur input as Text and output as Number type integer with Sign leading(-).Then try the unzone function in the output u will get the result as expected "-1235".

Cheers.!
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Hi
thanks for reply.

suppose my input is -123 and now the output should return -123

will this scenario works

and i have one more scenario

This is the input "123N" and the output is -12.35

how can i do this thanks
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange