How to Append the zeros to the existing column based on the length of the field value

[prashanthansi]

Hi,

Below is my requirement:

The length for the field value in a column should be minimum 5 digits. Irrespective of the length of the string available in the field.

Example: if the field value is 1, then the Alteryx should populate the value as 00001. or 

If the 12, then the value should be 00012 or 

if it is 123, then the value should be 00123.

Any help,

Thanks

[Emil_Kos · Accepted solution]

Hi @prashanthansi,

Please check this post I think it will give you all the answers you need!

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-I-pad-leading-Zeros/m-p/48669/h...

[ChrisTX · Accepted solution]

Use the PadLeft function.  Here is a list of all String functions:  https://help.alteryx.com/current/designer/functions-quick-reference

If your field is numeric, you'll need to first convert it to string.

Chris