Create unique record number certain format

[mikedesena]

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

[fmvizcaino · Accepted solution]

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

[bpatel]

hi @mikedesena ,

i used a slightly different approach. hope this helps!

[mikedesena]

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.