Date Filter to extract the latest record of a item

[Karl_Spratt]

Hi Community,

Need some help please.  I want to create a Date Filter to extract the latest record of a item.

Sample data below,  same Item no. has 4 records in the table, but I just want to pull the "newest" record using the effectivity_date can someone please explain how I'd do this, I tried a SAMPLE tool but I'm getting 2 records in my data. 

TIA

Karl. 

Item No.	effectivity_date	last_update_date	last_updated_by	creation_date	safety_stock_quantity
VA1-A888N	30/03/2020 00:00	30/03/2020 15:33	7568	30/03/2020 15:33	21
VA1-A888N	06/12/2019 00:00	06/12/2019 16:01	7599	06/12/2019 16:01	26
VA1-A888N	10/01/2019 00:00	10/01/2019 16:30	7599	10/01/2019 16:30	18
VA1-A888N	10/01/2018 00:00	10/01/2018 10:30	7568	10/01/2018 10:30	5

[atcodedog05 · Accepted solution]

Hi @Karl_Spratt 

Here is a workflow for the task.

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[JosephSerpis · Accepted solution]

Hi @Karl_Spratt I mocked up a workflow that converts the effective date field into a format Alteyrx recognises as Date Type then sort and then use a unique tool. Let me know what you think?

[messi007 · Accepted solution]

@Karl_Spratt,

please try this:

Attached the workflow

[atcodedog05]

Happy to help 🙂 @Karl_Spratt 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[Karl_Spratt]

Hi All,  

I tried all 3 solutions, in my data, all they all worked.. thank you  all so must, for your help, and sharing your knowledge. 

Cheers,

Karl. 

[SriNarendra]

Hi,

By using the summaries tool we can find the max value can you check the workflow it helps you. Feel free to reach out if you face any issues.