Skip to main content
Solved

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

  • September 26, 2018
  • 2 replies
  • 4 views
R
Forum|alt.badge.img

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

View original
Did this help you find an answer to your question?

2 replies

ebygomm
Influencer
Forum|alt.badge.img+38
  • ebygommInfluencer
  • Influencer
  • Best Answer
  • September 26, 2018

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

R
Forum|alt.badge.img
ebygomm wrote:

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


Helpful Members This Week

Community Stats

31,341
Posts
118,871
Replies
38,944
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.