Assigning Incremental Counter

alibink

I have looked around in the community posts but couldn't find this solution. 

I have a dataset like 

Account
A
A
A
A
A
A
A
A
A
A
A
A
A
B
B
B
C
C
C
C
C
D
D
D
D
D
D
D
D
D
D
E
E

and I want an output like the following

Account	Required Field
A	1
A	2
A	3
A	4
A	5
A	1
A	2
A	3
A	4
A	5
A	1
A	2
A	3
B	1
B	2
B	3
C	1
C	2
C	3
C	4
C	5
D	1
D	2
D	3
D	4
D	5
D	1
D	2
D	3
D	4
D	5
D	1
E	1
E	2

Criteria: 

The Counter in the 'Required Field' gets reset after:

1. On the 6th Record of Same Account or if 
2. The Account Changes before the counter could reach to 5

Any help would be much appreciated. 

I saw similar solution where the requirement of people was just to reset the number based on value in Account and it could be done using Unique Value of Tile Tool but here we have another criteria to forcefully restart numbering if counter reaches 5. I am attaching my incomplete workflow as well if that helps? Please note that in the attached workflow, I have setup the reset counter value at 7 not 5. 

Assigning Incremental Counter.yxmd

DanM

@alibink  check this tool out https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p/86603

you also have samples of this tool and how to create what you want under the Help in Designer. You can also take an interactive lesson on how to use the tool as well. It is a function that you will create to basically say by group start with 1 and add 1 until the group ends.