Alteryx Designer Desktop Discussions

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

how to use padleft Formula

PengJia
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 

2 REPLIES 2
john_miller9
11 - Bolide

@PengJia 


I would try the following:

 

Add 0 to middle.png

rohit782192
11 - Bolide

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

 

You can use Padleft directly in formula tool

Labels