Filter on duplicate rows with the greatest date while keeping any others

[lahughes]

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

[JordanB · Accepted solution]

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

[lahughes]

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