Solved

determine which feature with which feature have the same ID

  • 11 January 2023
  • 3 replies
  • 3 views

Badge +6

Hello FME Community,

I have a shapefile that contains an ID column. the ID must be unique, but I have data records that have come twice.

Only ID is the same and other columns are different.

with DuplicateFilter I filter Duplicate. so I get features that came twice. I would like to know that which feature with which feature have the same ID.

Thanks in advance for your help.

icon

Best answer by redgeographics 11 January 2023, 13:28

View original

3 replies

Userlevel 5
Badge +26

Instead of a DuplicateFilter you can use a Matcher, all features that match will be output through its Matched port.

Badge +6

Instead of a DuplicateFilter you can use a Matcher, all features that match will be output through its Matched port.

@Hans van der Maarel​ Thanks alot

Badge

There can be many ways to do this.

Using FeatureJoiner/FeatureMerger - after adding the records data you can get matched data from BOTH shape file and DataRecords.

Using DatabaseJoiner - can join the data records using the column ID.

Reply