Rownum with grouping
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have this input
NAME ID
EDWARDS LIFESCIENCES DRO 134-2
EDWARDS LIFESCIENCES DRO 134-1
EDWARDS LIFESCIENCES DRO 134-9
EL DORADO COATINGS INC. 821-4
EL DORADO COATINGS INC. 814-2
SHELL 432-1
I would like to create a rownum column group by the name,so the output it would be like the below :
NAME ID RecordID
EDWARDS LIFESCIENCES DRO 134-2 1
EDWARDS LIFESCIENCES DRO 134-1 1
EDWARDS LIFESCIENCES DRO 134-9 1
EL DORADO COATINGS INC. 821-4 2
EL DORADO COATINGS INC. 814-2 2
SHELL 432-1 3
Any idea how can i implemet this?
Thank you
Solved! Go to Solution.
- Labels:
- Datasets
- Expression
- Gallery
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
One way is to use the tile tool with “unique” tile method
https://help.alteryx.com/current/designer/tile-tool
dawn
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Another method is Multi-Row Formula with formula:
IF [Row-1:NAME]=[NAME] THEN [Row-1:RecordID] ELSE [Row-1:RecordID]+1 ENDIF
Workflow attached,
Karolina
