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 |
Solved! Go to 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:
@Aaron_Harter nailed it. The Tile tool should be set to "Unique Value" on the "Type" field, and be sure to check "Leave Unsorted".
Thank you Aaron,
I knew there is something in Alteryx to do such thing!
Many Thanks
Felix