Skip to main content
  • EN

Hi,

I am having an issue where I want to remove duplicate values from the results of the change detector and merge them all in to a single row to remove duplicate entries. I have provided an example below.

image.pngIf you need more information just ask.

 

Thanks.

@edstrat​ Use the ListExploder to split your change detector list into separate features.  Then:

  • use a first AttributeCreator to create temporary attribute names for new and old - something like:
_attrName_old    @Value(attributeName) Old
_attrName_new   @Value(attributeName) New
  • Use a second AttributeCreator and Attribute Value... to get the name of the attribute from the attribute value you created above:

image

  • Use Aggregator with Group By (with your unique record id) to bundle everything back together

 

If you comfortable in Python you could do this in a short PythonCaller script since FME list attributes and python attributes work well together - see the PythonCaller section at the bottom of is article.

.

Reply


Community Stats

30,126
Posts
114,351
Replies
37,758
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.