Skip to main content
Solved

Many to Many join using Feature Merger

raaaju1990
Contributor
Forum|alt.badge.img+6

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?
View original
Did this help you find an answer to your question?

2 replies

ebygomm
Influencer
Forum|alt.badge.img+38
  • ebygommInfluencer
  • Influencer
  • 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

@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.

Reply


Helpful Members This Week

Community Stats

31,344
Posts
118,866
Replies
38,934
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.