This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
hello, I am a beginner and i apologize if the question is reduntant.
I have a table that looks like this:
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:
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
Go to Solution.
Go to Solution.
you could use this:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Regards
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.
The best way to do this is with one tool: The Unique Only tool (Crew Macro Tab). I have attached a sample workflow.
thanks @afv2688 and thanks @tonyp, both solutions work just fine
you're attachment doesnt actually contain the macro, but I guess I can create one myself with the solution proposed above. thanks!
You may not have crew macros enabled / installed. I would highly recommend using them. The unique only macro / tool is pre-built.