Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

select rows with unique ID

Highlighted
7 - Meteor

hello, I am a beginner and i apologize if the question is reduntant.

 

I have a table that looks like this: 

IDVALUE
1 
1 
1 
2 
3 
3 
4 
5

 

 

the content of value really doesn't matter right now. I'd like to select only those rows for which ID is unique. this should be the result:

IDVALUE
2 
4 
5 

 

I can't think of an easy way to do this. Note that this is different from what Unique Tool does.

 

Can someone help? thanks

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hello @MassimoDM,

 

you could use this:

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Highlighted
10 - Fireball

Hi @MassimoDM 

I almost suggested the unique tool until I read to the end. Here's how you can do it!

 

Use a Summarise tool and add ID twice: Group by ID and Count ID. Then add a filter for Count = 1 (these are unique).

 

Finally join your input data back with the filtered unique IDs (Join ID = ID) to only return those records with unique IDs.

 

tonyp_0-1581684006144.png

 

Highlighted
11 - Bolide

The best way to do this is with one tool: The Unique Only tool (Crew Macro Tab). I have attached a sample workflow. 

 

Capture.PNG

Highlighted
7 - Meteor

thanks @afv2688 and thanks @tonyp, both solutions work just fine

Highlighted
7 - Meteor

you're attachment doesnt actually contain the macro, but I guess I can create one myself with the solution proposed above. thanks!

Highlighted
11 - Bolide

You may not have crew macros enabled / installed.  I would highly recommend using them. The unique only macro / tool is pre-built.    

 

Crew Macrows.PNG

Labels