Solved

I would like to select the most recently added attribute which has a duplicate ID on another line.

ruth_h
Rank
Badge +3

I have records with the same identifier but I would like to select the most recent activity on the record. So for example - 2 records with an ID of "2465100000" but against that ID are 2 different cross references added on different dates. I want to select the most recent one (or the oldest). Please can anyone advise as to the best way to do this so I have only one line remaining based on date. Many thanks

icon

Best answer by ebygomm 4 May 2021, 17:24

View original

2 replies

ebygomm
Rank
Userlevel 1
Badge +21

If you sort by date in descending order then use a duplicate filter, the features with the most recent dates will exit the unique port. The duplicates will exit the duplicate port.

 

If you want to keep the oldest instead, sort in ascending order

ruth_h
Rank
Badge +3

That's very helpful - thank you

Reply


Community Stats

28,719
Posts
109,500
Replies
36,560
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.