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 |
Solved! Go to 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!
You're most welcome @alexlyle !
Cheers.
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".