AnsweredAssumed Answered

Numeric map function (number format for exponents)

Question asked by madhushree.krishnamurthy@logicinfo.com on Aug 29, 2018
Latest reply on Aug 29, 2018 by amitash.pattnaik983074

I have a database profile as a source and I am getting a number in the exponential format for a field. In the destination, I would like to have it in the simple number format. how to go about this? I am trying to use number format function under mapping functions as the destination field needs to be in the character format. I have tried using #E0 as a input mask and ########## as output mask. but I am just getting the first number of the exponential value as output.

Outcomes