Skip to main content
Question

How do I make a one-to-many join in FME? for a line data

  • March 23, 2026
  • 3 replies
  • 40 views

rajendarkarra
Contributor
Forum|alt.badge.img+2

I have attempted to use the NeighborFinder transformer to achieve a one-to-many join; however, it is not producing the expected results.

In my case, the base dataset contains values such as 30,511 and 55,867, and my expectation is to match all records where the base value is greater than 30,511.

Since NeighborFinder does not seem suitable for this requirement, could you please suggest an alternative transformer or approach to achieve this condition-based matching?

Thank you.

 

3 replies

crutledge
Influencer
Forum|alt.badge.img+45
  • Influencer
  • March 23, 2026

Have you tried match or line on line overlayed? _overlay should give you a count.

Hope that helps!


rajendarkarra
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • March 23, 2026

Yes worked but i need below type of output.

 


itsmatt
Celebrity
Forum|alt.badge.img+47
  • Celebrity
  • March 23, 2026

By default the NeighborFinder is set to match just one feature. You can remove the number and instead add a search distance. 
To keep track of the which canridates matched to which base you can use a list

 


Alternatively you might want to check out the SpatialRelator. There you are able to choose the predicate (intersects, contains, etc...). The attributes work in a similar way in that you will need to generate a list to get a 1:M type join. 

After you have the list you can use a ListExploder to explode the list into features.

​​​​​​