How to append leading or trailing zeroes to a number
Sueann See
Experian Super Contributor
Aperture makes it very easy for you to append a chosen character to any value to achieve an overall length. You also have the option to add the character at the beginning or at the end.
To achieve this, look for the Pad function that you can use within a Transform step.
Example 1: To add leading zeroes to the value "1" in order to achieve a 5 characters length, the settings is as follows:
Example 1: To add trailing zeroes to the value "1" in order to achieve a 5 characters length, you will have to check on "Align left"
1