Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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