Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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