Skip to main content

Hey everyone, I hope I am just missing a very obvious point here. 

I am trying to compare two SQL input data sources

One with these columns

And the other with these columns

 

The customer and account number combination is going to be my primary key. I need to extract the email addresses of customers based on that combination. 

I have tried the feature merger which seemed to be the obvious solution, but I am not getting any matches?

Any idea where I am going wrong? 

Hi ​@navid.fotovaty ,

I think FeatureMerger or FeatureJoiner is a way to go, but it's hard to say what is wrong unless you would clarify specifically how you are using FeatureMerger in your workspace.


Hi Takashi, 
Here you go 

 

and this is the result
 

 


The fme_rejection_code EXTRA_REFERENCEE_FEATURE shown in your result table indicates that there were supplier feature with duplicate join key - pair of C_ACCOUNT and C_CUSTOMER. How to resolve this would depend on how you would like to treat supplier features with an identical key.


Hi Takashi, 

I would need to allow for duplicate to exist, is that possible? I can introduce another column with a unique identifier if needed. 


I think it would be a good solution to add another unique ID column as join key to the two input tables, if possible.


Reply