Assigning ID numbers to 3 rows consecutively for data set

Hi Alteryx community,

I'm attempting to achieve a loop function in Alteryx to add ID #s to my records. A simple one will work where I start with 1 and +1 every 3 records. My data set looks like the the screenshot here:

And I would like it to look like this:

I'm not sure how to even start going about this besides using the sort tool to put the records in order. I picture I will need to somehow reference the record before and evaluate if it equals the 2 before it to determine if +1 needs to occur.

Thank you in advance to anyone that takes the time to help!

Best,

Dylan

Macros

Accepted answers

Luke_C

Hi @Breauxdeur

Assuming your data follows the pattern of the sale being the first item in the grouping, you could use a multi-row formula tool like so:

New Workflow10.yxmd

binu_acs

@Breauxdeur

All comments

Luke_C

Hi @Breauxdeur

Assuming your data follows the pattern of the sale being the first item in the grouping, you could use a multi-row formula tool like so:

binuacs Thanks!

Luke_C Thank you, helpful for when the data sets are too big for the tile tool

binu_acs

@Breauxdeur the Tile tool should work for the large data set as well, you need simply update the Number of tiles based on the total number of records, If you have total of 12 records and you want to group them with the size of 3 then divide the total number of records by group in this case 12/3=4, then assign the result in the number of tiles column

Breauxdeur

In this instance, I had millions of transactions and the title tool wouldn't let me input a number high enough

NaiduRj

This was really helpful. Thank you very much.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703