• EN
Solved

Many to Many join using Feature Merger

  • 18 March 2020
  • 2 replies
  • 48 views
raaaju1990
Rank
Badge +5

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?

 

 

icon

Best answer by ebygomm 18 March 2020, 10:46

View original

2 replies

ebygomm
Rank
Userlevel 1
Badge +21
The FeatureJoiner would be better suited to this, is there a reason for not using that?
M
Badge +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


Community Stats

28,818
Posts
109,853
Replies
36,633
Members
Terms & ConditionsCookie 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.