community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

fill up 2 digit entries to 4 digit ( 22 to 0022)

Asteroid

Hi all

 

I have a fiels which has entries like

 

1488

323

2

1499

..

 

How is it possible to fil up the 1 to 3 digit entries with 0 in front to get a 4 digit entry with  leading zeros ?

 

1488

0323

0002

1499

 

Many thanks in advance

 

Steffen

 

Highlighted
Quasar
You would want a formula tool with

Padleft([field],4,”0”)
Alteryx Certified Partner
Alteryx Certified Partner

Hi @vizda 

 

@neilgallen is right. I just would add up that you need to convert your numeric field to a String type before using the formula.

 

Cheers,

Labels