Skip to main content
  • EN

Hi There,

Apologies in advance if the title is a mess. Not quite sure how to better word this problem I've encountered. Essentially I want to isolate (and discard) and GROUP where any of the entries involved has

First off, let me show what my data looks like:

TYPEGROUP1A1A1A1B2B1B1C1C1C

I'd like to isolate all GROUPS where any of the TYPE values are "2", Like Group "B" in this example. Even if a group has 100 entries and only 1 of them has value 2, that entire group and all its entries needs to be identified.

Any ideas on how to easily achieve this?

Best regards,

Find all the groups you wish to discard by testing for type, then use this to merge back to the input and keep only the unmerged output

Find all the groups you wish to discard by testing for type, then use this to merge back to the input and keep only the unmerged output

Simple yet effective. Works perfectly, thanks a lot!

Reply


Community Stats

30,159
Posts
114,480
Replies
37,807
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.