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
Solved
I would like to select the most recently added attribute which has a duplicate ID on another line.
+4- Contributor
Best answer by ebygomm
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
+32- Influencer
- Best Answer
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.