select rows with unique ID

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

Accepted answers

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.

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 @tonypreece, 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!