Adding Identifier

[dunkindonut7777]

Hi I want to know if how can I add a ascending order identifier of each line just like the fill in series function in excel. I want to add a number every location. See sample below:

Code	Location	Identifier (Expected Output)
11111	California	California1
11111	California	California2
22222	Ohio	Ohio1
22222	Ohio	Ohio2
44444	Texas	Texas1
44444	Texas	Texas2

How can I add another identifier column considering there are thousands of lines reflected in the data? Thank you so much for the helo

[Raj]

Use multifield formula tool to achieve this output

[Raj]

PFA

[FinnCharlton]

Hi @dunkindonut7777 , here's how you accomplish this:

We start by creating a unique identifier for each duplicate location. We can do this with the multi-row formula tool grouped by location - doing this we ensure we start counting again for each new location. We can then use a formula tool to create the Identifier column.

[binuacs]

@dunkindonut7777 Another method using Tile tool