Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Group by Record ID

DataKiller
7 - Meteor

Hello everyone, 

    I need your help!

 

I added Record ID in a new column, and filtered by the conditions, then I got the file which I attached. you can see the record ID jump from 4 to 10, 13 to 20. so I would like to add a new column of ID to group of 1-4, 10-13,20-26

 

Record IDTimeSpeed
1123
2223
3323
4423
10523
11623
12723
13823
20923
211023
241123
261223
3 REPLIES 3
jasperlch
12 - Quasar

Hi @DataKiller 

 

This could be achieved by adding a Multi-Row Formula to create a new group ID:

 

if [Record ID] = [Row-1:Record ID] + 1 then [Row-1:New Group ID] else [Row-1:New Group ID] + 1 endif

 

Capture.PNG

 

 

DavidP
17 - Castor
17 - Castor

Hi @DataKiller 

 

I would use a multi-row formula, like this

 

DavidP_0-1597303621377.png

 

DataKiller
7 - Meteor

Perfect!

Labels