Expand Record ID tool

[simon]

Ok the time has come to expand functionality in the record ID tool. I would like the ability to restart the counter based on a field (e.g zip code). You can do it quickly in Tableau (see image) so why not have this functionality readily available in Alteryx? Sure, you can already do it in Alteryx - the long way - with the generate rows tool, look at previous/active row with certain condition and do +1 or something like that.

Having a simple restart counter in Record ID tool just makes sense. It's intuitve to have it there, and it's easier to use than generate rows tool. IMHO also easy to develop by Alteryx and +1 for Alteryx in gartner magic quadrant! 

[PeterPetersen]

I could have used this today.However @jroot's solution also helped me out. Good input.

[jineshnp31]

Would love to see this in the next release! Saves some additional steps for sure. 

[MarqueeCrew]

@patrick_digan @SeanAdams ,

I'm posting a CReW GroupBY Record ID macro to the gallery.

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

[MarqueeCrew]

Until this happens, here's a new CReW macro that will do the job ....

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

[patrick_digan]

Thanks @MarqueeCrew !!!

[Kenda]

Thanks @MarqueeCrew ❤️

[NicoleJ]

Exciting update coming soon to a Record ID tool near you! 😁

[NicoleJ]

Check out the new Group By functionality that we added to the Record ID tool in the 24.2 release! This will be a great way to restart the counter with each new grouping :)