Skip to main content
Solved

How to join two datasets without a common field

  • July 18, 2016
  • 2 replies
  • 54 views

gisgeek
Contributor
Forum|alt.badge.img+9

I have two datasets - I want to join them I guess like a union but don't know what the equivalent command is in FME. Feature merger doesn't work because I don't have a common field in both tables ie. AssetID in one table and AssetID in another. So basically it is a join on the geometry I am trying to do. What is the best way to do this?

Best answer by erik_jan

A join on the geometry can be done using the NeighborFinder, one of the Overlayer transformers (AreaonAreaOverlayer etc) or the SpatialRelator.

Many options to do a spatial join (and I am sure I missed some more).

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
  • Contributor
  • Best Answer
  • July 18, 2016

A join on the geometry can be done using the NeighborFinder, one of the Overlayer transformers (AreaonAreaOverlayer etc) or the SpatialRelator.

Many options to do a spatial join (and I am sure I missed some more).


gisgeek
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • July 21, 2016

A join on the geometry can be done using the NeighborFinder, one of the Overlayer transformers (AreaonAreaOverlayer etc) or the SpatialRelator.

Many options to do a spatial join (and I am sure I missed some more).

Spatial Relator was the best option and got the results I wanted - thank you