We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎02-17-2022 07:05 AM

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

 

 

Reply
1 REPLY 1
atcodedog05
22 - Nova
22 - Nova
‎02-17-2022 07:07 AM

Hi @Sshasnk 

 

You can achieve this using pad function like below

 

atcodedog05_0-1645110425061.png

 

Hope this helps : )

 

add 0.yxmd
Reply
Community Live
Labels
Top Solution Authors
View All