Skip to main content
Solved

How to join two tables and keep the duplicates (one to many relationship)

  • July 26, 2017
  • 2 replies
  • 50 views
D

Hi,

I'm trying to join two tables using the FeatureMerger and I have enabled the Process Duplicate Supplier since my Suplier table has got more than one entry for each of the Requestor entries I'm trying to match. However, I'd like it to keep all duplications from the Supplier table so that the total Merged includes duplicate rows from the Supplier. Is there a way to achieve this?

Thanks!

Best answer by erik_jan

Hi @de8a88,

You got the right approach but most likely need to enter a list to store the suppliers:

Or if possible exchange the Requestors and Suppliers, so each Requestor will have one Supplier.

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

erik_jan
Contributor
Forum|alt.badge.img+23
  • erik_janContributor
  • Contributor
  • Best Answer
  • July 26, 2017

Hi @de8a88,

You got the right approach but most likely need to enter a list to store the suppliers:

Or if possible exchange the Requestors and Suppliers, so each Requestor will have one Supplier.

D
  • de8a88
  • Author
  • July 26, 2017

That with a List Exploded did the trick, Thanks!

Community Stats

32,154
Posts
122,047
Replies
39,812
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.