Skip to main content
Question

Remove duplicate entries

  • April 22, 2016
  • 3 replies
  • 87 views
T
Forum|alt.badge.img

Dear FME community,

I have a road network which has duplicate entries. The attributes differs just in one attribute ("bescheid_nr"), all other attributes are the same in the example. I want to keep only the feature with the highest number in the attribute "bescheid_nr" when all other values are the same. In the screenshot the feature 2 to 6 should be removed. They are not valid. Is there a way how I can filter them out so only the first entry in the screenshots gets preserved (all 5 have different geometries)?

Kind regards

Thomas

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

ebygomm
Influencer
Forum|alt.badge.img+48
  • ebygommInfluencer
  • Influencer
  • April 22, 2016

Take a look at the matcher

patrick_koning
Contributor
Forum|alt.badge.img+7

Put them all in a listbuilder sort the list and then take the desired item from the list.

Be sure to keep the geometry if you wat to keep it in a different attribute so you can restore it after the listbuilder and sorter. In the list the geometry gets lost. but with a geometry extracter into an attribute and after that a geometryreplacer to restore the geometry it should work just fine.

L
Forum|alt.badge.img
  • larry
  • April 22, 2016

Hello,

If your duplicates are only attribute based (no need to match the geometries), I'll do it this way.

  1. Sort your features based on bescheid_nr (Sorter)
  2. Filter out the duplicates based on grundbescheid_nr (DuplicateFilter)
  3. Keep the unique and merge back the duplicates based on grundbescheid_nr and bescheid_nr (FeatureMerger)

Regards,

Larry

Community Stats

32,431
Posts
123,238
Replies
40,557
Members
Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.