Data Extraction

talebi

Forums

Hi Brian
I have a question for youPlease have a look at the screen shot I attached. I need to pull employees who have the same department and position in the whole table.For instance, Employee ID = 2 has the same department (c) and the same position (Admin) but employee ID = 1 changed the department and position. Also Employee ID = 3 is in the same department but changed the position. I am looking for such an Employee ID = 2
I do not know how to use criterias for such a probelm or write scripts
Thanks

Brian Element Mon, 08/22/2022 - 10:26

This is simple.  Perform a summary by Employee ID, Department and Position.  Any transactions that only have 1 as the number of records would be an employee that has the same department and position.  So in your scenarion employe 1 would have two transactions, employe 2 would have 1 and employe 3 would have 2.  Then just do a criteria for the number of records = 1 to get the employees you are looking for.  If you need all the transactions then just do a join back to the original files of the employees with one record.

Hopefuly this makes sense.