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

Filtering out date on th bases of Update Date & Time

sgaryali
8 - Asteroid

Hi

 

I am having situation where I want to take unique data on the bases of updated date & time.

 

If it was only date I could have used summarize tool to take the Max date option.

But here I have both situation either there can be new updated date or in the same date I will be having updated time.

 

I have to take the latest date & time.

How can we achieve this?

 

 

Attaching file for reference.

 

Thank you in advance.

1 REPLY 1
binuacs
21 - Polaris

@sgaryali I think yon can still use the summarise tool to get the max date and time from the updated date field

 

binuacs_0-1662706208876.png

 

Labels
Top Solution Authors