Start Free Trial

Alteryx Designer Desktop Discussions

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

if account number is less than 9 digits add zero

Sshasnk
8 - Asteroid

Hi I have an account number where some of them does not have 9 digits in account number

example:

 

Account number
026548756
25698895
45789
458795

 

Output:

 

Account number
026548756
025698895
000045789
000458795

 

 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @Sshasnk 

 

You can achieve this using pad function like below

 

atcodedog05_0-1645110425061.png

 

Hope this helps : )

 

Labels
Top Solution Authors