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!
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