Adds a group by option into Record ID tool

[Jean-Balteryx]

I often need to create a record ID that automatically increments but grouped by a specific field. I currently do it using the Multi-Row Formula tool doing [Field-1:ID]+1 because there is no group by option in the Record ID tool.

Also, sometimes I need to start at 0 but the Multi-Row Formula tool doesn't allow this so I have to use a Formula tool right after to subtract 1.

So adding a group by option to the Record ID tool would allow the user not to use the multi-row formula to do this and to start at any value wanted.

[mceleavey]

@Emil_Kos ,

yeah I agree.

Alteryx Gods, is there any chance of getting this functionality built in to the standard tool?

[DavidP]

It would be great if I didn't have to use the Tile tool to do this anymore!

[SeanAdams]

Hey @Jean-Balteryx - this is such a common need, it comes up at least once every few days.    as a few folk have said above, usually I use the Tile tool to get around this - but that doesn't seem to make sense (since Tile tool should be used for tiling rather than a grouped record ID).

This is also a tool that many people build when they are first starting out with the SDK - and so it seems like an easy addition to the main product.

[NicoleJ]

Better keep an eye out for an exciting update coming soon to a Record ID tool near you... :) 

[mceleavey]

I wrote a version of the RecordId tool that does this. You need to add an option to group by that resets the count on each change of x, ie 1,2,3,1,2,3 OR to change at each each change in x ie, 1,1,1, 2,2,2

This would be good though. 

[NicoleJ]

Check out the new Group By functionality that we added to the Record ID tool in the 24.2 release!