Alteryx Designer Desktop Discussions

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

Multi Row Incrementation

ethankutch
7 - Meteor

Hello,

 

Looking for a Multi Row tool formula that increments a record ID every other instance. For instance if the Record ID field is 1,2,3,4 I would like a formula that increments 1,1,2,2,3,3,4,4. Can anyone help out?

 

Thanks!

3 REPLIES 3
binuacs
20 - Arcturus

@ethankutch one way of doing this

image.png

binuacs
20 - Arcturus

@ethankutch Another method

image.png

Dina
9 - Comet

Just another way.

 
 

Screenshot 2023-08-04 122539.png

 

Labels