Skip to main content

Hello Forum,

 

I need to find the records from one dataset where the value in one of its attributes is the same as the value of an attribute in another dataset.

 

For example, If I have two datasets (A and 😎 I want the output to show which records in A have shared value in B, based on a specified attribute. I want the output to be a selection of A. Something like this…

 

 

I’ve tried Matcher, but that didn’t work for me.

 

Thanks,

Stuart

You can use the FeatureMerger or the FeatureJoiner to do this. For the FeatureMerger your table A can be your requestor and table B can be your supplier. You need to tell FME on which fields to join in the settings of the FeatureMerger. The same is basically true for the FeatureJoiner but it is faster and uses syntax which might be more recognizable if you are used to databases and SQL.


I wonder why the Matcher didn't work for you…

In Table B change the name of attribute Number to ID, and you can use the Matcher. The features that are present in both tables will exit from SingleMatched.

Using this same idea, you van also use a ChangeDetector. In that case the features that are present in both tables  will exit from Unchanged.

 


Ah, of course, FeatureMerger.

I’ve just built the workspace using a FeatureMerger on the real data. It does exactly what I needed. Thanks.


Reply