Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

Alteryx Designer Desktop Discussions

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

find last record based on date

Christian_Pezzei
5 - Atom

Hi community,

 

I'm trying to find the last record based on the date. 

The input and output would be something like this (sorry for the german date format):

Alteryx_Com_Quest_find_last_record.jpg

 

I've tested the attached worklow but it's not the solution I'm searching for.

 

Could you please help me out?

 

thx in advance.

 

Regards

Chris

2 REPLIES 2
echuong1
Alteryx Alumni (Retired)

Sort the records on date by descending. From there, use a sample tool with K = 1 and group by with the ID.

 

echuong1_0-1584626457932.png

 

Christian_Pezzei
5 - Atom

Thank you very much.....works out fine.

 

regards

Chris

Labels
Top Solution Authors