Assigning ID numbers to 3 rows consecutively for data set

[Breauxdeur]

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

[Luke_C · Accepted solution]

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 · Accepted solution]

@Breauxdeur 

[Breauxdeur]

@binuacs  Thanks!

[Breauxdeur]

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

[binuacs]

@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