Alteryx Alternative to Excel Text Function

[PKoya]

Hi,

I am trying to achieve an outcome similar to the example below where I want to convert a number of less than or equal to 8 digits into a string as this would be a unique identifier and needs to be concatenated with another string.

E.g. 12345 will become 00012345.

I am sure its something very simple and I have looked around but I am unable to find a solution to this.

If anyone can suggest a solution, it would extremely helpful.

[Emil_Kos · Accepted solution]

Hi @PKoya,

This is the formula that you are looking for:

FieldName

PadLeft(ToString([FieldName]),8,"0")

Please mark my post as a solution if this was helpful!

[Emil_Kos]

Hi @PKoya,

Just in case you would need a sample workflow:

The output: 

[PKoya]

Thanks, @Emil_Kos for your solution. 🙂