Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Does the Unique Tool return Unique Rows when all elements in a row are selected?

jonnyrask
8 - Asteroid

For example.

 

Is using a Unique and passing in A B and C as the checked values then is this what happens?

 

I want:

ABC
123
456

 

When this is the input:

ABC
123
123
456
3 REPLIES 3
fmvizcaino
17 - Castor
17 - Castor

Hi @jonnyrask ,

 

You are absolutely right about that.

Here is an example.

fmvizcaino_0-1593044887329.png

 

Best,

Fernando Vizcaino

 

estherb47
15 - Aurora
15 - Aurora

@jonnyrask 

Yes. The unique items will stream out from the U output, and the duplicated ones will stream out from the D output.

Cheers!

Esther

BenMoss
ACE Emeritus
ACE Emeritus

Hi!

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

Learn more about Accepted Solutions here.

Thank you!

Labels
Top Solution Authors