make 10 digits number

Question

HI all,

need your help. i have set of loan number. e.g 12345, 456789,

i need make it 10 digit number by adding zero (0) in front of it... ex. 12345 should be 0000012345 as output.

thanks in advance i'm beginner in alteryx

apathetichell · Accepted Answer

first off - those are strings. not numbers. - this is a key point - a string can have leading 0s - a number cannot. you must use a string field.

second -:

padleft(tostring([field]),10,"0")