Exclusion command in IDEA

ortizmario6025…

Forums

I'm trying to get a table that doesn't have duplicate records, but I've been unable to do so by applying the IDEA Exclusion command. It's easy to do in Excel, but I haven't been able to do so in IDEA.

Is there a way to get this result in IDEA?
For Example
I want it to extract non-duplicate records.
...................................................................................Thanks, I already saw the command to get what I want

Brian Element Tue, 06/17/2025 - 09:35

IDEA has a task for this but it is hidden in the duplicates so it is not obvious.  Select the Analysis ribbon, Explore group, Duplicate Key - Duplicate Key Detection and you then have an option to "Output records without duplicates" which I think is what you are looking for.