RESET RECORD ID BASED ON ROAD

Question

Hello -

I wanted to see if there was a way to reset the record ID based on a group of records.

For example, I have 6 records of data which are separated by facility. Please see attached.

My goal is to have a record ID for each line reset if the facility is changed.

Example Data.xlsx

BrandonB · Accepted Answer

Use a Multi Row formula with the create new field and do the following:

Make sure that you check the box to group by the facility field. This is what groups them together

binu_acs · Accepted Answer

@LorenzTaylor another option with tile tool