community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Lastest Date

Highlighted
Meteoroid

Hi, I could not seem to find an appropriate answer to my question. I need to separate out a record based on the latest date.

Sample data attached, some records are duplicated as with Amy and Jamie, I need to obtain their latest employer based on the last end date, also include blank fields which could indicate a current employer.

 

Any suggestions?

Alteryx Certified Partner

Hi @Shibiko 


Is this dataset you're looking for?

Solution.PNG

 

 

Change the Input to your file path.

Cheers,

 

Asteroid

Sort by name ascending , and end date by descending this will ensure the null values are first and then use summarize to group by name and all other columns first . give it a try and see if it serves your purposeCapture.PNG

Meteoroid

Thank you! :)

Labels