This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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