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
Page 1 / 1
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
That's very helpful - thank you