Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! 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

Maintaining original recordID when filtering data in the new Interactive Browse Tool

Now that 2019.2 is officially released I'll raise this here as I know it was raised as part of the beta testing. With the new interactive browse tool when filtering results the record numbering restarts.

 

For example in this window from a weekly challenge, I originally have this:

Interactive Results 1.PNG

Then when I filter on the Allocated column for records where the Allocated amount is 0, I get this:

Interactive Results 2.PNG

And as you can see the Record on the left hand side is numbered 1 - 15, so when trying to locate one of these lines to check the formula is working as expected it makes it difficult to isolate, where as if I knew that filtered record 10 was actually record 394 in the data I can then scroll to that point.  

 

I know a solution to this would be to add a record ID field to the data, but this is not always needed.

4 Comments
patrick_digan
17 - Castor
17 - Castor

+1 This would be a great addition

matthewhoyle99
6 - Meteoroid

Hi @cgoodman,

 

I work on an ITGC engagement for PwC in the Manchester office, I think this would be a really useful addition!!

 

 

SeanAdams
17 - Castor
17 - Castor

That would make the filtering very visually obvious (like the behaviour in Excel).   this request makes a lot of sense.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes