How to append leading or trailing zeroes to a number

Sueann See
Sueann See Experian Super Contributor
edited December 2023 in Tips and tricks

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"