Skip to main content
  • EN

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?

 

 

The FeatureJoiner would be better suited to this, is there a reason for not using that?

@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

30,195
Posts
114,616
Replies
37,859
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.