Skip to main content
Solved

How to: Feature based Filter?


pkno
Contributor
Forum|alt.badge.img+5
  • Contributor

Hello everyone,

I was wondering if there is a simple way to filter one Dataset by comparing key-values with another Dataset. Basically a Join but onlky keeping Left Attributes.

Example:

Dataset1
 

Project SubID moreAttributes from Dataset1
ABC 1 ...
ABC 2 ...
DE 1 ...
DE 2 ...

 

Dataset 2:

 

Project SubID different Attributes from Dataset2
ABC 1 ...
ABC 1 ...
ABC 3 ...
ABC 3 ...
DE 2 ...
FG 3 ...

 

I want to Filter Dataset 2 to only keep the ABC|1 and DE|2 rows because they match dataset 1. I am sure I could accomplish this via join and subsequently throw out all the Attributes that were introduced from dataset 1, but I was wondering if there is an easier way. 

Thanks all

Best answer by ebygomm

Why not just keep only the projectID and SubID from dataset 1 and then use that in a FeatureJoiner of FeatureMerger?

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

4 replies

koulsoum
Contributor
Forum|alt.badge.img+10
  • Contributor
  • March 14, 2025

Hi ​@pkno , I think you can create an attribute ‘dataset’ (dataset = 1 for the first and dataset = 2 for the second one)  then use the Transformer Matcher with Selected attribute : Project, SubID, and from the port matched use a tester to filter ‘dataset’ = 2

 


ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • Best Answer
  • March 14, 2025

Why not just keep only the projectID and SubID from dataset 1 and then use that in a FeatureJoiner of FeatureMerger?


pkno
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • March 14, 2025
ebygomm wrote:

Why not just keep only the projectID and SubID from dataset 1 and then use that in a FeatureJoiner of FeatureMerger?

 

Why didn’t I think of that, that should be it. Thanks


ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • March 14, 2025

You could always use an InlineQuerier, if you wanted to do it in one step

 

 


Reply


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