Repeat RecordId based on row sequence
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
- Labels:
- Custom Tools
- Expression
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Brilliant. It works like a charm
Many thanks
