Skip to main content
Question

How to transform change detector results into the same row.

  • March 2, 2023
  • 1 reply
  • 11 views
edstrat
Participant
Forum|alt.badge.img

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
Forum|alt.badge.img+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


Helpful Members This Week

Community Stats

31,328
Posts
118,863
Replies
38,957
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.