Solved

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

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!

icon

Best answer by erik_jan 26 July 2017, 19:02

View original

2 replies

erik_jan
Rank
Userlevel 2
Badge +12

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

That with a List Exploded did the trick, Thanks!

Reply


Community Stats

28,663
Posts
109,333
Replies
36,532
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.