hello, I am a beginner and i apologize if the question is reduntant.
I have a table that looks like this:
ID | VALUE |
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:
ID | VALUE |
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
¡Resuelto! Ir a solución.
Hello @MassimoDM,
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
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.
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!
You may not have crew macros enabled / installed. I would highly recommend using them. The unique only macro / tool is pre-built.