Create Unique customer number

[dvdispo]

i want to create a unique customer number with alteryx.  To achieve that i'm taking the first 3 letters of the company name and i want to add a sequence number.

For exemple:

Albano - needs to be alb-001

Alber - needs to be alb-002

Albertson - needs to be alb-003

Alden - needs to be ald-001

How can we do that?

thanks 

[alexnajm]

With a Formula tool (like you have) followed by a Multi Row formula! Workflow incoming:

[kamal03]

Hi @dvdispo 

Please try the below workflow, and let me know if it worked for you or not.

[dvdispo]

thanks alexnajm,

Seems to do what i want

thanks

[dvdispo]

Hi @kamal03

Seems to do what i want

thanks 

[HomesickSurfer]

Hi @dvdispo 

3 tools

• Create a CustomerID as a string, size 3
• Change the string to 7 or more characters length
• Apply a formula to the CustomerID field as follows: Left(REGEX_REPLACE([Field1],'\s+',''), 3)+"-"+[CustomerID]
• This accounts for possibility of the Company Name (Field1) having any leading or trailing whitespace

[alexnajm]

@dvdispo fantastic! Please accept the post (or posts) that helped the most with your question so others can see what was most helpful 😊