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
- 11 replies
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
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.
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.
+44- Influencer
- 3427 replies
- 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