Forum Discussion
Get just one date from multiple rows with the same date
I've found a way to solve it for my specific case, matching up the term date with the last day with client date (since they should only match when the employee has been termed anyway). Thanks for the replies all!
Anonymous may be easier is that in query editor, make copy of your table, remove all unwanted columns, keep emp name, hire and terminate date and remove duplicate rows. At the end you will have unique row for each employee and then it will be much easier to work from there.
parry2k Thanks for your reply! This sounds good, but the problem is that I will need attrition to eventually be broken up by departmentCommonName and empLocation, but if I remove those columns in another table I won't know which people were in which group when I try to add them up. Any suggestions?
Anonymous well if you don't have termination date by department, you cannot achieve that anyhow so not sure how you are planning to do it?
parry2k I do have termination date by department actually, it is shown as the lastDayWithClient column. Sorry for not explaining it thoroughly! What is most important here for me right now is actually empLocation, where I need to be able to count and break out attrition by empLocation which has multiple categories. This is why I wanted to get a column which shows the hire and termination date only once per person so that once I broke it out by location, it would not overcount attrition.