Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Assigning Sequential numbering based on duplication

Felix776
8 - Asteroid

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?

 

TypeValue
A28.02091
A20.36035
B69.8712
B107.4819
B51.73652
B61.40197
C101.0117
C35.28572
C77.92513
C3.786827
D3.336206
D84.95498
D120.6517
E89.55876
E78.62291
E71.47302
F100.0821
F32.22199
F105.7135
F104.1362

 

 

To 

 

 

No.TypeValue
1A28.02091
2A20.36035
1B69.8712
2B107.4819
3B51.73652
4B61.40197
1C101.0117
2C35.28572
3C77.92513
4C3.786827
1D3.336206
2D84.95498
3D120.6517
1E89.55876
2E78.62291
3E71.47302
1F100.0821
2F32.22199
3F105.7135
4F104.1362

 

3 REPLIES 3
Aaron_Harter
11 - Bolide

@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:

1.PNG

2.PNG

CharlieS
17 - Castor
17 - Castor

@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
8 - Asteroid

Thank you Aaron,

 

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

 

Many Thanks

 

Felix

Labels