Skip to main content
  • EN

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

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

 

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

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

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

 

 

Community Stats

31,788
Posts
120,757
Replies
39,405
Members

Latest FME

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.