SOLVED
make 10 digits number
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Johmz
8 - Asteroid
‎02-29-2024
06:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI all,
need your help. i have set of loan number. e.g 12345, 456789,
i need make it 10 digit number by adding zero (0) in front of it... ex. 12345 should be 0000012345 as output.
thanks in advance i'm beginner in alteryx
Solved! Go to Solution.
Labels:
2 REPLIES 2
apathetichell
19 - Altair
‎02-29-2024
06:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
first off - those are strings. not numbers. - this is a key point - a string can have leading 0s - a number cannot. you must use a string field.
second -:
padleft(tostring([field]),10,"0")
‎02-29-2024
06:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks. Very helpful