Employee attrition calculation

[santhoo_san]

Hi,

I have a set of data of employees for two months, where in I do not have any employee joining or releaving dates. But, I have to identify the Addition and Deletion of employees by comparing the employee IDs. (means if an employee ID available in the previous month and not available in the current month identify it as deletion of employee. similarly if an employee ID is not available in the previous month and available in the curent month that is addition). I have attached sample data. Please suggest.

Regards,

Santhosh

[danielrozental]

Santhosh, you might want to consider adding empty rows in months where you don't have data.

[santhoo_san]

Hi Daniel,

I did not understand how this would help in comparing the data.

[#4]

Hi Santosh,

You can use Mapping table to check out the presence of EMP ID for respective months

EX :

TBL 1:

Previous month

TBL 2

Present Month

Use Applymap function in your main table to check the presence

Hope this helps

Regards

Mallik

[#5]

Hi Santosh,

You can use Mapping table to check out the presence of EMP ID for respective months

EX :

TBL 1:

Previous month

TBL 2

Present Month

Use Applymap function in your main table to check the presence

Hope this helps

Regards

Mallik

[#6]

Hi Santhosh,

create table employees: as concatenate load for both month with an additional attribute LoadDate as for Excel column D.

then load as table diff: EmpID and Count(LoadDate) #emp grouping by EmpID

next join that diff with employees where #emp = 1 and LoadDate is not the new load date

these are the ones from the old load that do not reappear in the new load => the deleted ones.

Ciao

Klaus