Forum Discussion

EWBWEBB's avatar
EWBWEBB
Helper III
2 years ago

Remove duplicates based on condition

Hello,   I'm trying to establish how I can remove the duplicates from set of data but chose the one to remove based on a condition.    I have a record of people currently off work. These entries...
Need Help
BA_Pete's avatar
BA_Pete
Super User
2 years ago

Hi EWBWEBB ,

 

I may be oversimplifying this, but can't you just group on [Name] and [FIRST DAY], then add an aggregated column that is MAX of [RESUMED].

 

It gives you this:

 

Pete

  • EWBWEBB's avatar
    EWBWEBB
    Helper III
    2 years ago

    I'll give this a go - I thought i tried it and it came up with a strange error but I'll need to loop back to it to try it out. 

    Thanks