Preserving leading zeroes in numerical constant value mappings

If you need to map a numerical value to a constant value and that constant value has leading zeroes, those zeroes will be parsed off.  For example, if want to map a numerical field to a constant value of 00000000115 and you enter a constant value in the mapping wizard, the transformation logic will truncate the leading zeroes.  This results in a constant value of 115 instead of the desired value.  There is a workaround for this behavior using the ReplaceAll() function.

For example you can map the numerical field as follows: =ReplaceAll(ABC0000000115, ABC, "").  This will result in a string being returned from the function: "0000000115".  When the transformation converts this string into a number, it will then preserve the leading zeroes.

Comments (0)

Skip to main content