Solved

Identify group of attributes where any amount of entries in another attribute has specific value

Forum|Forum|7 years ago
September 26, 2018
2 replies
8 views

robbie_botha
70 replies

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,

Best answer by ebygomm

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.