We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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

"Unique" tool should offer an option to select "unknown" or "unique by rows"

"Unique" tool should offer an option to select "unknown" or "unique by rows"

 

vizAlter_1-1620869296298.png

 

2 Comments
vizAlter
12 - Quasar

Also, currently the Unique tool is case sensitive.

Hence it is good if users could get an option to make a choice, see the example below:

 

vizAlter_0-1622107799936.png

 

Another point — Suppose we have 100 Invoice IDs, and 20 records are duplicate but some are duplicates for multiple times.

Hence, it's a good point if users could have an additional output anchor to display only the 20 records (unique values) which have duplicates.

vizAlter_1-1622108864717.png

 

CristonS
Alteryx Community Team
Alteryx Community Team

hi @vizAlter thanks for this feedback, especially about case sensitivity! In terms of the "unique from duplicates," you could use another Unique tool; I know adding another tool isn't always the best solution. As soon as this idea meets the necessary criteria, we will pass it along to our product management team.