We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Ideas

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

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

Submission Guidelines

Expand Record ID tool

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! 




9 - Comet

Alternative to the long way, call it a medium way.  I use a "Formula" tool to create a dummy field with a value of 1 then the "Running Total" tool to generate the counter.

Alteryx Alumni (Retired)

Hi @simon,


Is this functionality the same as what you would achieve with a group by in the Record ID tool? 




11 - Bolide

Hi Ben,


I get Access Denied on your link. "You do not have sufficient privileges for this resource or its parent to perform this action."

From the title link, it does sound similar.



Alteryx Alumni (Retired)

Hi @simon,


Okay, we'll verify the functionality is similar to what Tableau provides.  We will look at adding this in a future release.



Alteryx Alumni (Retired)
Status changed to: Accepted
17 - Castor
17 - Castor

Hi all,

One of the most common uses of RecordID is to try to generate a unique record ID within a group.  For example the last column in the data set below

Customer     Book   Row ID    CustomerBook ID

A                  A         1              1

A                  B         2              2

A                  C         3              3

B                  A         4              1

B                  B         5              2


I know that this can be done by splitting, or multi-row formulas etc - but this could be done very easily by borrowing cleverness from some of the other components and just adding a group-by field to the Record ID control.

So - in the example below - I'd put a recordID component, with a group by on Customer, and this would then auto-generate the CustomerBookID column.


This is something that a few of us doing weekly challenges have had to hack around many many times - and would be a useful addition to the record ID tool  ( @mceleavey@MarqueeCrew@NicoleJohnson)


17 - Castor
17 - Castor

it looks like this may be a duplicate of an idea that's already on the roadmap:



Apologies for the duplication, and thank you to @simon , and @BenG for getting this on the roadmap


17 - Castor
17 - Castor

I must apologise - I've accidentally posted a duplicate of your idea in a new idea here:


@BenG / @TaraM - could you assist with getting my duplicate idea (link above) marked as a duplicate and shut down?



8 - Asteroid

Maybe I don't understand your requirements 100%, but I've accomplished something similar using the tile tool. Tile method would be Unique Value in the Zip Code field. You'd have a tile number for each zip code and a sequence number per tile for each record with the same zip code.

17 - Castor
17 - Castor

+1. Any updates on this idea?