Filter on duplicate rows with the greatest date while keeping any others
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In my data output below you will see I have the potential for there to be a separate instance (or instances) of a row based on the "valid from" date.
In these instances, how can I get my output, such that I keep only one instance, and that being the one with the latest valid from date? The example below could have 1 or more duplicates based on date, and I want to keep just the row with the latest date. So I would end up in the example below with rows, 13, 14, 16, 17, 18, 19, 20 in my output.
My guess is a formula that says, is Item Number and Component are the same, then look at the Valid From and keep the latest date. But I cannot figure out how to write it or if there is an even better way to accomplish the task.
Thanks,
Larry
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @lahughes
You could sort the data based on item number, component and valid from date. The use the unique tool to take the first record (Latest date)
See workflow attached.
Best,
Jordan Barker
Solutions Consultant
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much @JordanB
As a new user to Alteryx, I find that I have a tendency to over-complicate what turns out to be so simple using the tools provided. :) Your solution worked perfect.
Thanks,
Larry
![](/skins/images/A7612391DEAF4EF69C140133EA533832/responsive_peak/images/icon_anonymous_message.png)