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?
Solved! Go to 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.
@dunkindonut7777 Another method with the tile tool
Thank you. It works