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
thanks alexnajm,
Seems to do what i want
thanks
Hi @kamal03
Seems to do what i want
thanks
Hi @dvdispo
3 tools
@dvdispo fantastic! Please accept the post (or posts) that helped the most with your question so others can see what was most helpful 😊