Assigning Sequential numbering based on duplication

[Felix776]

Hi Alteryx users,

Any one can show me how to add a new column to the table below so that I can add sequential numbering to the left of column "type" and rest when the value changes in column Type?

Type	Value
A	28.02091
A	20.36035
B	69.8712
B	107.4819
B	51.73652
B	61.40197
C	101.0117
C	35.28572
C	77.92513
C	3.786827
D	3.336206
D	84.95498
D	120.6517
E	89.55876
E	78.62291
E	71.47302
F	100.0821
F	32.22199
F	105.7135
F	104.1362

To 

No.	Type	Value
1	A	28.02091
2	A	20.36035
1	B	69.8712
2	B	107.4819
3	B	51.73652
4	B	61.40197
1	C	101.0117
2	C	35.28572
3	C	77.92513
4	C	3.786827
1	D	3.336206
2	D	84.95498
3	D	120.6517
1	E	89.55876
2	E	78.62291
3	E	71.47302
1	F	100.0821
2	F	32.22199
3	F	105.7135
4	F	104.1362

[Aaron_Harter · Accepted solution]

@Felix776  the Tile tool can perform this function.  Take a look at the Example Canvas in Alteryx, specifically the unique column example.  A select tool may be required after to rename the "Tile_Num" field to "No." and place it as the first field in your data table:

[CharlieS]

@Aaron_Harter nailed it. The Tile tool should be set to "Unique Value" on the "Type" field, and be sure to check "Leave Unsorted". 

[Felix776]

Thank you Aaron,

I knew there is something in Alteryx to do such thing! 

Many Thanks

Felix