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