Sequencing

[alexlyle]

I have a set of codes that will appear on multiple rows. How can I number their occurrences?

Ex: take

CODE1

CODE2

CODE3

and make

Code	Seq
CODE1	0
CODE1	1
CODE1	2
CODE2	0
CODE2	1
CODE2	2
CODE3	0
CODE3	1
CODE3	2

[bpatel]

hi @alexlyle ,

is this what you are looking for?

[RobertOdera · Accepted solution]

Hi, @alexlyle 

Try this.

Leverage Multi-Row Formula Tool to auto generate Sequence for every group of Code (i.e. Code1, Code2, etc.,)

Please mark as solution + like, if this works for you.

The workflow is attached.

Cheers!

[RobertOdera · Accepted solution]

You're most welcome @alexlyle !

Cheers.

[ScottG]

Don't forget the sometimes-overlooked Tile Tool.  This is useful for automatically providing a sequence number without having to use the Multi-row Formula Tool.  If you configure the tool for Tile Method "Unique Value", then there will be a sequence number for all records that have the same value.  The sequence will be output in a new field named "Tile_SequenceNum".