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 Filename1MD51SHA11CRC321SHA-2561SHA-5121SHA-3841Full1Modified1Created1Entry1File1File1Product1Identical1Extension1File1Filename2MD52SHA12CRC322SHA-2562SHA-5122SHA-3842Full2Modified2Created2Entry2File2File2Product2Identical2Extension2File2

Repeat RecordId based on row sequence

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

Tips and Tricks

Custom Tools

Expression

Accepted answers

Yoshiro_Fujimori

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

1281616.yxmd

All comments

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