Multi-Row with Various Number of Rows

[PWaicus]

Hi - I'm trying to use the Multi-Row Formula tool to add an ID number to a set of records (the data will eventually be cross-tabbed, as the values will need to become the field names).  The challenge is that there is a different number of rows to group for each ID.  So using a standard +/- number of rows does not work, as each grouping could have a various number of rows in the raw data.  Essentially what I'd like to do is assign an ID number to all rows from where the value is "First Name" down through the last row prior to the next one with a value of "First Name".  Sample data is included in the attached workflow. 

Thanks! 

[NickSm]

@PWaicus 

Can work around the variable number of rows by first using a formula to create a marker whenever you come across a "First Name" entry.  Then your multi-row can just look one record above and see if it's null or was filled by the formula.  

Attaching a quick example workflow.

[Thableaus]

Hi @PWaicus 

Does a Multi-Row formula like this work for you?

IF [F1] = "First Name" THEN 1
ELSE [Row-1:ID] + 1 ENDIF

Cheers,

[Claje]

Another version of this that uses one Multi-Row Formula - I created an integer field called RecordID but it should be pretty easy to change this.

IF [F1] = "First Name" THEN [Row-1:RecordID]+1 ELSE [Row-1:RecordID] ENDIF

[JosephSerpis · Accepted solution]

Hi @PWaicus This syntax should work for you with the multirow tool

[PWaicus]

Thanks much!!!