This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The beauty of Alteryx is there are many ways to get the job done. Here is another option for you that uses the Padleft() function in Alteryx.
Like the other posters noted numeric values will not be able to retain the leading zeros. First convert your ZIP Code to a string with a select tool, make sure that the length of the field is at least 5, then with a Formual Tool use the PadLeft() function. You will need to specify the field you want to use, the length the final string needs to be, and the value to put in front of the existing sting. Your function might look like this
[Postcode] = Zip code field
5 = length of final string (the total length of a ZIP Code)
"0" = value to put to the left of strings shorter than 5