Skip to main content
Question

Merge Attributes of Duplicate Features into one

  • February 16, 2016
  • 1 reply
  • 975 views
K

Hi all,

 

 

I'm fairly new to FME and having some difficulty with duplicate features, with one different attribute.

 

 

The case I'm dealing with is Estate Proprietors, where I need to show the owners of a property.

 

The table provided treats every Proprietor separately, despite them being applied to exactly the same property. I need to merge the Proprietor attribute of the different features (based on same ID) into the same feature.

 

 

Simplified Example:

 

 

Proprietor ID

 

Bob Jones 1234

 

Mary Jones 1234

 

Me Limited. 1235

 

John Smith 1236

 

Kate Smith 1236

 

 

The output I want to achieve is

 

 

Proprietor ID

 

Bob Jones, Mary Jones 1234

 

Me Limited. 1235

 

John Smith, Kate Smith 1236

 

 

 

I am able to concatenate attributes of a single feature, but am unsure how to merge these multiple features into one.

 

 

Can anyone provide assistance or suggestions as to how I would go about this?

 

 

Cheers,

 

Kieran
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • February 16, 2016

Hi, you can use the Aggregator transformer with this setting.

  • Group By: ID
  • Attributes to Concatenate: Proprietor
  • Separator Character: ,
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,431
Posts
123,238
Replies
40,557
Members
Terms & ConditionsCookie settingsAccessibility statement
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.