Skip to main content
Question

3 FeatureMergers or 1 InlineQuerier

  • November 25, 2016
  • 3 replies
  • 62 views

daveapegg
Contributor
Forum|alt.badge.img+4

Hi guys,

I have a point dataset A that is buffered from point dataset B by 50, 100 and 150 metres, with resulting 3 tables.

I want to merge all three tables via unique ID number but I only want each record to display once i.e. a point within 50 metres will be in all three tables, I only want the 50 metre point... a point within 100 metres will show in the 100 metre table and the 150 metre table, I only want the point from the 100 metre table.

Is it better to use multiple FeatureMergers (3) to get the desired output or to use an InlineQuerier. I don't have strong SQL skills so any examples would be appreciated. Using FME 2015.1

Thanks in advance,

Dave.

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.

3 replies

itay
Supporter
Forum|alt.badge.img+19
  • Supporter
  • November 25, 2016

Hi @daveapegg, I would suggest using the MultiBufferer and that way avoid your issues with duplicate ID's.

Hope this helps.


takashi
Celebrity
  • November 25, 2016

Hi @daveapegg, if you already have the three tables, I don't think you have to think of merging them. Just read the three tables in the order of buffer size ascending (50m, 100m, 150m), you can then discard duplicate points with a DuplicateFilter (DuplicateRemover in FME 2015) easily.


daveapegg
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • November 28, 2016

Thanks heaps for your answers guys, very much appreciated!