Create unique record number certain format
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry if i have a bad title. I am trying to create a unique identifier for 100k records with the following format "C201900000010000, C201900000020000". Counting up for every record in the excel. The format should always be the same number of characters.
i do not know how to use actual coding in alteryx, but just a basic user with the main buttons. any help would be appreciated.
It could even be C201900000000001 then C201900000000002 and so on if that is easier. Thank you all, i hope someone sees this. Could even be C20191, C20192, C20193, etc if we had to go that route. most important is start with C2019. thank you
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @mikedesena ,
I've attached an example showing how to do it with a formula tool and the padleft and padright function.
Take a look and let me know if this makes sense to you.
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
just want to say thank you truly for your time. i am still trying to mentally follow the pad left and pad right (like i get it but gotta do it on my own to learn). You taught me something new and i hope you can take some pride in that!! have a great day, next drink is on me.
