Auto assign unique ID based on another field

[Ylin0615]

I would like to find out if I can use Alteryx to assign unique ID based on the criteria below:

ID format: Project value + 2 digits (0-9,A-Z)

Project	ID
A	A00
B	B00
C	C00

Thanks!

Betty

[Qiu]

@Ylin0615 
My understanding is that you want to assign the sequencen number for each project then form the ID,

We can use the Tile tool to generate the Sequence number or Record tool if you are using a recent version of Alteryx.
Or we can generate some randome numbers to form the ID as below.

[ChrisTX]

In the Preparation category, try the RecordID tool.  See attached workflow.

Chris

[Ylin0615]

Thank you for the reply and sorry I wasn't clear.

Since there are total 3 chars for the ID field. the first char is project ID so I only have 2 digit left as ID assignment.

My issue started when over 100 items if only use number.

Is there a function to combine letter and number?

So when running out of numbers, e.g.A99. the next one will be AA0 (or AA1) , it also need to be unique within the same project.

Data	Option1	Option2
Project	item	ID1	ID2
A	1	A00	A01
A	2	A01	A02
A	91	A90	AA1
A	92	A91	AA2
A	93	A92	AA3
A	94	A93	AA4
A	95	A94	AA5
A	96	A95	AA6
A	97	A96	AA7
A	98	A97	AA8
A	99	A98	AA9
A	100	A99	AB1
A	101	AA0	AB2
A	102	AA1	AB3
A	103	AA2	AB4
A	104	AA3	AB5
A	105	AA4	AB6
A	106	AA5	AB7
A	107	AA6	AB8
A	108	AA7	AB9
A	109	AA8	AC1
A	110	AA9	AC2

[Qiu]

@Ylin0615 
I think there must be a smart way, but I I managed to do it like below with the fuction "IntFromChar".