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

JosephSerpis

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.