Create Unique customer number

Question

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

Test15.yxzp

alexnajm · Answer

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

HomesickSurfer · Answer

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

dvdispo · Answer

Hi @kamal03

Seems to do what i want

thanks