Grouped RecordID

[mceleavey]

Hi all,

I see a lot of people have been requesting this so I thought I'd post this here.

I built a grouped RecordID tool that allows you to create a record ID that uses one or more fields as grouping:

Say you have data like this:

and you want to create a RecordID field, but rather than just counting from 1 to 5, you want to group it by the District field, and reset the count at each change in this field, then you can now use this tool to do exactly that:

Nice and simple but a useful bit of functionality methinks.

Thanks to the handsome and talented @joshuaburkhow for making it look pretty and helping out with some of the testing.

Enjoy.

M.

[Kenda]

@mceleavey 

I agree, I see a need for this all the time here on the community! In the past, I used @MarqueeCrew's CReW macro but it looks like he has some competition now!

https://gallery.alteryx.com/#!app/CReW%2BGroupByRecordID/5e417bbf0462d70decb763a9  

[atcodedog05]

This would be really helpful 🙂 thank you @mceleavey  and @joshuaburkhow

@joshuaburkhow and @cgoodman3 your today's inspire session on Design Patterns was really amazing and helpful 🙂

[Luke_C]

This is awesome and a great alternative to the tile tool. I always get confused with all the different settings while configuring it to do something like this.

[atcodedog05]

Hi @Luke_C 

Tile tool has a drawback it will always sort the data ascending by unique column 😶 i usually get stuck because of this and end up using multi-row formula to generate group id.

[Qiu]

@mceleavey 
Thank you for this help handy one.
ACE ideas digest of @SeanAdams guided me here. 😁

[srea541]

This solution is fantastic - Thank you for sharing!