Reset value at change from another field

I want to create a sequence of numbers (1,2,3,etc.) in Field 2 that resets when the last value of Field 1 changes e.g., 63031C004 changes to 63031C005. What would be the best way to do this?

Field 1 Field 2

63031C004 1

63031C004 2

63031C004 3

63031C004 4

63031C004 5

63031C004 6

63031C005 1

63031C005 2

63031C005 3

63031C006 1

Common Use Cases

Accepted answers

patrick_digan

Use a multi-row tool, group by Field1 and your formula would be something like [Row-1:NewField]+1

All comments

patrick_digan

Use a multi-row tool, group by Field1 and your formula would be something like [Row-1:NewField]+1

DataBlender

The tile tool could also be used. Choose unique values as the method then select field 1 as the unique field.

You'll get two fields outputted:

Tile_num will be a sequential list increasing every time field 1 changes.

Tile_sequenceNum will be a sequential list within the field 1 group:

Field1	Tile_Num	Tile_SequenceNum
63031C004	1	1
63031C004	1	2
63031C004	1	3
63031C004	1	4
63031C004	1	5
63031C004	1	6
63031C005	2	1
63031C005	2	2
63031C005	2	3
63031C006	3	1

ianl

Thank you! that worked great.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703