Skip to main content
Question

Join table after clipping

  • November 24, 2016
  • 4 replies
  • 34 views

simonhume
Contributor
Forum|alt.badge.img+2

Hi

 

I've set up a workspace to extract certain types of businesses (a MapInfo point dataset that I have a tester attached to to extract the types) that lie within an employment area (a MapInfo polygon table).

 

Using the Clipper function, this workspace runs fine and i get a result output into a MapInfo table.

 

The output table includes all the attributes from the point dataset, but i want to also include the attributes from the Employment Areas dataset (only 2 columns, but they're both useful) attached to each record in the output table.'

 

I have tried many of the Feature, Attribute and Spatial functions, but cannot get the 2 tables to be merged into one after the Clipper has extracted the data.

Apologies in advance if this isn't explained very clearly. Am a new user of FME so am still on a steep learning curve to understand what to do when when setting up a Workspace! Hopefully someone can answer my query

thanks

Simon Hume

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.

4 replies

redgeographics
Celebrity
Forum|alt.badge.img+62

You can try the PointOnAreaOverlayer to do an overlay, although the Merge Attributes parameter in the Clipper transformer should be able to do this as well.


takashi
Celebrity
  • November 24, 2016

Hi @simonhume, try checking the "Merge Attributes" checkbox in the Clipper parameters dialog.


itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • November 24, 2016

Next to what @takashi mentions, beware of possible attribute conflicts between the 2 feature types (point and polygons) and use the accumulation mode and conflict resolution accordingly.

Hope this too helps


simonhume
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • November 29, 2016

Good morning all

Apologies for the delay in replying, but your suggestions have worked and i now have the workspace running as i require

Thanks to all for their replies

regards

Simon Hume