Lastest Date

[Shibiko]

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?

[Thableaus · Accepted solution]

Hi @Shibiko 

Is this dataset you're looking for?

Change the Input to your file path.

Cheers,

[Avinash_K]

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 purpose

[Shibiko]

Thank you! :)