Skip to main content
Solved

How can I select object by attribute from aggregated objects

  • October 14, 2015
  • 2 replies
  • 29 views
M
Forum|alt.badge.img
Hi,

 

How can I select object by attribute from aggregated objects

 

I have an excel files with 1000 lines and shapefile with 100 lines and I have a common id.. I did a Featuremerge to add attributes from excel to geometry. In the result I have 1000 lines (or 100 lines if I do an aggregation with id). I want to have in the result only 100 objects with the recent date (Example for object with id=5 I have in excel date=2015/05/12 with type =x1 and 2015/01/01 with type x2 and I want that id =5 have the attribute of 2015/05/12 with x1)..

 

Thanks for help

Best answer by takashi

Hi,

 

 

I would try filtering the Excel line features, before the FeatureMerger. e.g.

 

Sort the Excel lines by the date descending with a Sorter, and select the first line (i.e. most recent) in each group of lines having the same "id" with a DuplicateRemover (Key Attributes: id). 

 

 

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

2 replies

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • October 14, 2015
Hi,

 

 

I would try filtering the Excel line features, before the FeatureMerger. e.g.

 

Sort the Excel lines by the date descending with a Sorter, and select the first line (i.e. most recent) in each group of lines having the same "id" with a DuplicateRemover (Key Attributes: id). 

 

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
M
Forum|alt.badge.img
  • miladahmad
  • Author
  • October 15, 2015
thanks.. it works... (I did the Sort and DuplicateRemover after FeatureMerger and it is ok also)

 

 

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

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.