Skip to main content
Solved

Many to Many join using Feature Merger

  • March 18, 2020
  • 2 replies
  • 349 views
raaaju1990
Contributor
Forum|alt.badge.img+9

I have two tables having ID column in common. These IDs are repeated multiple times in both the tables. Now I need to merge these two tables into a single table based on this ID field. I tried using Feature Merger, but the results were not as expected. Some data were missing. Is there any effective way to do a many to many join in FME?

 

 

Best answer by ebygomm

The FeatureJoiner would be better suited to this, is there a reason for not using that?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • Best Answer
  • March 18, 2020
The FeatureJoiner would be better suited to this, is there a reason for not using that?
M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • March 18, 2020

@raaaju1990 As @ebygomm suggests try FeatureJoiner.

FeatureMerger is more complex and you probably need to set Process Duplicate Suppliers and also Generate List. Then you need to use ListExploder to split the lists. FeatureJoiner should also be faster.

Community Stats

32,076
Posts
121,798
Replies
39,707
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.