Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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

"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

 

3 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 Alumni (Retired)

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.

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