Forum Discussion

EWBWEBB's avatar
EWBWEBB
Icon for Helper III rankHelper III
3 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
Icon for Super User rankSuper User
3 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
Icon for Helper III rankHelper 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