Adding a series identifier

[dunkindonut7777]

Hi I have a data here that I want to add a unique identifier to each codes. See sample in the table below \:

Code	Unit	UniqueIdentifier (ExpectedOutput)
10000	ACR	ACR_1
10000	ACR	ACR_2
20000	ACR	ACR_1
20000	ACR	ACR_2
20000	GER	GER_1
20000	GER	GER_2
30000	ACR	ACR_1
30000	REG	REG_1
40000	REG	REG_2
50000	GII	GII_1

I want to create an identifier every product code. How can I perform this?

[DataNath · Accepted solution]

Hey @dunkindonut7777, here's how I'd do that - just creating a grouped RecordID with the Multi-Row Formula tool, grouping by code. Then use a Formula tool to create the UniqueIdentifier.

[binuacs · Accepted solution]

@dunkindonut7777 Another method with the tile tool

[dunkindonut7777]

Thank you. It works