Repeat RecordId based on row sequence

[ste_demi]

Hi All,

is there a way to have a new column that repeats RecordIDs when the sequence of row contents starts again? As you can see, the content of column 1 restarts again after 17 records. I would like something similar like in Column 2

Column1Column2

Filename	1
MD5	1
SHA1	1
CRC32	1
SHA-256	1
SHA-512	1
SHA-384	1
Full	1
Modified	1
Created	1
Entry	1
File	1
File	1
Product	1
Identical	1
Extension	1
File	1
Filename	2
MD5	2
SHA1	2
CRC32	2
SHA-256	2
SHA-512	2
SHA-384	2
Full	2
Modified	2
Created	2
Entry	2
File	2
File	2
Product	2
Identical	2
Extension	2
File	2

[apathetichell]

Use Multi-row formula - create a new integer field called column2

if [row-1:column1]=null() then 1 elseif [column1]='Filename' then [row-1:column2]+1 else [row-1:column1] endif

Might a bit off on my syntax but that's the general idea.

[ste_demi]

Apologies but I fear I have confused the query. I have, at the moment, one column (RegExOut1). If I use RecordID tool, it will generate unique numbers; however, as you can see from the pattern, the values in RegExOut1 repeat. I would like to have a recordID that only changes when the pattern restarts again. Hence the table of my initial post where I have recreated the result I am looking for in Column2. Does it make sense?

RegExOut1

FILENAME

MD5

SHA1

CRC32

SHA-256

SHA-512

SHA-384

FULL PATH

MODIFIED TIME

CREATED TIME

ENTRY MODIFIED TIME

FILE SIZE

FILE VERSION

PRODUCT VERSION

IDENTICAL

EXTENSION

FILE ATTRIBUTES

FILENAME

MD5

SHA1

CRC32

SHA-256

SHA-512

SHA-384

FULL PATH

MODIFIED TIME

CREATED TIME

ENTRY MODIFIED TIME

FILE SIZE

FILE VERSION

PRODUCT VERSION

IDENTICAL

EXTENSION

FILE ATTRIBUTES

[Yoshiro_Fujimori · Accepted solution]

Hi @ste_demi ,

Does this expression in Multi Row Formula tool make sense?

IF [RegExOut1] = "FILENAME"
THEN [Row-1:RecordID] + 1
ELSE [Row-1:RecordID]
ENDIF

[ste_demi]

Brilliant. It works like a charm

Many thanks