Question

How to transform change detector results into the same row.

  • 2 March 2023
  • 1 reply
  • 1 view
E
Badge

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.

1 reply

M
Badge +2

@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

28,661
Posts
109,324
Replies
36,528
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.