Question

Remove duplicate entries

  • 22 April 2016
  • 3 replies
  • 8 views
T
Badge

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

3 replies

ebygomm
Rank
Userlevel 1
Badge +21

Take a look at the matcher

patrick_koning
Rank

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
Badge

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

Reply


Community Stats

28,729
Posts
109,527
Replies
36,565
Members
Terms & ConditionsCookie settings
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.