Output a number that is 4 characters in length

[poles1c]

Hi,

I need to output a number that is 4 characters in length. For example, if the number is one then I want it to be represented as 0001. How can I do this in Alteryx?

Thank you,

Courtney

[patrick_digan · Accepted solution]

Off the cuff I would say use a string variable and the padleft function. If you have a numeric variable to start with, it would be something like: 

Padleft(Tostring(Field),4,"0")

[poles1c · Accepted solution]

Thank you for your help. Will this method work even if the number increments? e.g. say the number increases to 100, will this formula automatically output 100 as 0100? 

[poles1c · Accepted solution]

Nevermind just realized it works! Thank you!!