Alteryx Designer Desktop Discussions

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

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

You can achieve this using pad function like below

Hope this helps : )

if account number is less than 9 digits add zero