Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Adds a group by option into Record ID tool

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.

17 Comments
atcodedog05
19 - Altair

This one is amazing 😎

phoebe_kelley
8 - Asteroid

yes! This would be super helpful as an option. Like others have said, it is possible with other tools but it would be nice to have in the simple recordID tool.

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Revisit

Thank you for the feedback!

 

Our product team has reviewed this idea and determined we're unable to include it on the near future roadmap at this time. However, we would like to keep it in mind for future roadmap decisions and tool enhancements. We'll do our best to update this idea when our product team has reevaluated it for roadmap inclusion.

CharlieS
17 - Castor
17 - Castor

This already exists with the TIle tool. Set the tile methods to "unique value" and select the field you'd like to group by. 

Shifty
11 - Bolide

We have a macro for this that @mceleavey built. I use it all the time!

mceleavey
16 - Nebula

Hi all,

 

I posted this tool in the Designer Discussion area.

Enjoy.

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Grouped-RecordID/m-p/762043#M183914

 

M.

Sharkey
6 - Meteoroid

I just add a column that contains 1 for every row (using a formula) and then add a running total on that column, grouping by whatever is required. Gives a record Id by group using 2 very simple steps.