Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Grouped RecordID

mceleavey
16 - Nebula

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:

 

mceleavey_0-1621518051553.png

 

Say you have data like this:

 

mceleavey_1-1621518130491.png

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:

 

mceleavey_2-1621518212423.png

 

mceleavey_3-1621518232748.png

 

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.

 

 

4 REPLIES 4
Kenda
15 - Aurora
15 - Aurora

@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
18 - Pollux

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
13 - Pulsar

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
18 - Pollux

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.

Labels