Sequence of Numbering

I tried my best to find a solution but couldn't get an idea. Hence approaching the community page for help and guidance.

Example:

Column A Column B

1 3

2 3

3 3

4 3

1 4

2 4

1 5

2 5

In the above example, column A should start every time with sequential series numbers as 1,2,3, depending on number if Identical numbers in Column B.

Example, 1 - There are four 3's in Column B, accordingly I mentioned as 1,2,3,4 in column A.

Example 2 - There are two 4's in Column B, accordingly I mentioned as 1,2 in column A

Any help in this regard is highly appreciated.

Thanks,

Surya

Alteryx Practice

Accepted answers

abacon

@Chsp2404 This workflow should get you the desired output. I did 2 options, the recordID option for if you are on 2024.2 or later and the multi-row option if you are on an older version.

Bacon

Sequence of Numbering.yxmd

All comments

abacon

@Chsp2404 This workflow should get you the desired output. I did 2 options, the recordID option for if you are on 2024.2 or later and the multi-row option if you are on an older version.