Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx Alternative to Excel Text Function

PKoya
8 - Asteroid

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.

 

PKoya_0-1614343777023.png

 

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.

3 REPLIES 3
Emil_Kos
17 - Castor
17 - Castor

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
17 - Castor
17 - Castor

Hi @PKoya,


Just in case you would need a sample workflow:

 

Emil_Kos_1-1614345517621.png

 

The output: 

 

Emil_Kos_0-1614345509548.png

 

PKoya
8 - Asteroid

Thanks, @Emil_Kos for your solution. 🙂

Labels
Top Solution Authors