Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

how to use padleft Formula

Highlighted
5 - Atom

Hello All,

 

I have a number 50 and 41 I would like to adding a zero in the middle so 400 and 401, how do i do that with padleft??

 

thank you 

Highlighted
Alteryx Partner

@PengJia 


I would try the following:

 

Add 0 to middle.png

Highlighted
8 - Asteroid

PADLEFT([ZIP], 5, "0")

 

You can use Padleft directly in formula tool

Labels