Multi Row ID Grouping

[PWaicus]

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

[MarqueeCrew]

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

[JosephSerpis · Accepted solution]

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.

[PWaicus]

Thank you!!!