Alteryx Designer Desktop Discussions

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

Unique Record ID Every 9 Records

dwilliams3
6 - Meteoroid

Hi, I am struggling to figure this out. I'd like to create a new column with a unique ID for every 9 records, starting with "1" for the first 9 records. Example below: Incoming data set is FieldNum, Name, Value and I'd like to produce RecordNum column. Appreciate your help.

 

dwilliams3_0-1684966515998.png

 

5 REPLIES 5
geraldo
13 - Pulsar

@dwilliams3 

 

geraldo_0-1684968190010.png

 

flying008
13 - Pulsar

Hi, @dwilliams3 

 

1- If your every N records number in formula can  manual input, you only need use Floor function to calculation it.

 

2- If you want dynamic calculate group by field [Name], please follow process by below step:

 

录制_2023_05_25_09_49_09_986.gif

dwilliams3
6 - Meteoroid

Thanks to you both. Great solutions!

hlee36
8 - Asteroid

I used basic algebra to come up with a formula since we know RecordNum increments by 1 after 9 records.

hlee36_0-1685180012527.png

hlee36_0-1685209509566.png

hlee36_1-1685209529974.png

 

 

mithily
8 - Asteroid

@hlee36  very elegant solution

Labels