Skip to main content
  • EN
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
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
thanks.. it works... (I did the Sort and DuplicateRemover after FeatureMerger and it is ok also)

 

 

Reply


Community Stats

30,108
Posts
114,295
Replies
37,745
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.