+4Hey 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?
Best answer by takashi
I think it would be a good solution to add another unique ID column as join key to the two input tables, if possible.
Hi
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.
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.
+4Hi 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.
