Employee present or absent?

[Karahs]

Hello everyone,

               My question is that i have data with months and their employee Id, i want to find the diffrence between the employee id with respect to months.

Eg. some of the employee Id is present in Jan and some of the employee Id are not there in Feb that means they have left the company,how will i come to know which employee left in that month?

Thanks!!

[swuehl]

There are different approaches:

a) just make selections in month to see the existing and not existing id, or in an id to see the month with an relation

b) have a look at something like

New/Lost/Returning/Loyal Customers

or

Intervalmatch Count Open Items

[Ralf-Narfeldt]

Emp:

Load *, MakeDate(Year,Month) As MonthDate;

Load * inline [

Employee,Year,Month

A,2016,1

B,2016,1

A,2016,2

B,2016,2

A,2016,3

A,2016,4

];

LastMonthWorked:

Load *, Year(FinalDate) &'-'&Month(FinalDate) As FinalMonth;

Load

Employee, Max(MonthDate) As FinalDate

Resident Emp Group By Employee;

Result of LastMonthWorked is:
A     2016-Apr

B     2016-Feb