Skip to main content
Question

Can you force a 1 to 1 relationship with FeatureJoiner?

  • October 10, 2019
  • 5 replies
  • 160 views

Forum|alt.badge.img

I need to join fields from one table to the another. Because of the nature of the join, I only want one match per record. If there is more than one match, that is redundant data. It looks as though the FJ is adding records when there is more than one match.

Can I tell it to take the first match, so that my output has no more records than the input - "Left" table?

 

Thank you,

 

Randy McGregor

5 replies

takashi
Influencer
  • October 10, 2019

Hi @ramcgreg, I don't think the FeatureJoiner has such an option to do that unfortunately.

A possible workaround is to connect a DuplicateFilter to the Left port in order to filter out duplicate features after joining.

Alternatively the FeatureMerger with the Process Duplicate Suppliers option could also be used instead of the FeatureJoiner.


bernarddinon
Forum|alt.badge.img+1

Hi,

 

 

For this case, I agree with @Takashi, FetaureMerger with the Process Duplicate Suppliers option is a good solution. I use it a lot to Join objet with 1-1 link.

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • October 11, 2019

@ramcgreg

 

Use a Sampler in Grouped By mode prior to sending it to the joiner.

Is a fast solution to boot.


ebygomm
Influencer
Forum|alt.badge.img+33
  • Influencer
  • October 11, 2019

If the duplicate suppliers are truly redundant, and the duplicates don't contain any information that you are interested in, I'd use a duplicatefilter on the data going into the right port of your featureJoiner


Forum|alt.badge.img
  • Author
  • October 11, 2019

Thanks everyone. Several useful answers. I appreciate it. I will take a look and let you know how it goes!


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