community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Multi Row ID Grouping

Meteor

Hi - I have a dataset where the [User ID] field could be similar across a various number of rows (they are not duplicate records, as other fields are different).  I just want to assign a unique number to any row or groups of rows with matching [User ID].  So if there are 3 rows with [User ID]="123", they would all get a new ID field with the same number, as shown below.

 

User ID     Record ID

123           1

123           1

456           2

789           3

789           3

789           3

789           3

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
If you use a multi row formula tool you can check to see if user equals row-1 user. If equal assign row-1 I'd. Otherwise row-1 I'd plus 1.

Sorry about iPhone answer.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx Certified Partner

Hi @PWaicus if you use this syntax "IF [User ID]=[Row-1:User ID] THEN [Row-1:Rank] ELSE [Row-1:Rank]+1 ENDIF" in the Multi Row tool it should produce the output you described.

 

MultiRow100819.JPG

Meteor

Thank you!!!

Labels