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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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

 

Bolide
You would want a formula tool with

Padleft([field],4,”0”)
Highlighted
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