We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

data investigation

bh1789
8 - Asteroid

2022-07-01

2023-08-01

2022-06-01

2024-06-01

2024-07-01

2024-08-01

 

How would I filter data to only keep data with the most recent date of 2024-08-01?  The data is coming through as a "date" type

 

Thank you!

 

 

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

Summarize to find the MAX of Date, and use a Join after to the original data to find those where the Date matches the Max_Date

 

Data -------------------------> Join ----->

   |                                                      |

   |-----> Summarize ------> |

cjaneczko
13 - Pulsar

You can use a Summarize tool with it set to the Max Date.

Labels
Top Solution Authors