Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Lastest Date

Shibiko
6 - 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?

3 REPLIES 3
Thableaus
17 - Castor
17 - Castor

Hi @Shibiko 


Is this dataset you're looking for?

Solution.PNG

 

 

Change the Input to your file path.

Cheers,

 

Avinash_K
8 - 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

Shibiko
6 - Meteoroid

Thank you! :)

Labels