Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
9 - Comet

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