Hi Team, Anyone can help me with to calculate the employee entries from a time sheet data. Time sheet table: Employee NameEmployee IDDateHoursA102-08-20218B202-08-20218A103-08-20218B203-08-20218A104-08-20218A105-08-20218B205-08-20218 In this table Employee B has missed to enter the hours for 4th August. So how do I calculate the Employee Name & id and missing date from the table. My input files are 1. Timesheet Dump as like the table above 2. List of the employees. Please help with the logic. Thanks in advance. Regards, Amrit

How to calculate Missing Employee Entries

Hi Team,

Anyone can help me with to calculate the employee entries from a time sheet data.

Time sheet table:

In this table Employee B has missed to enter the hours for 4th August. So how do I calculate the Employee Name & id and missing date from the table.

My input files are

1. Timesheet Dump as like the table above

2. List of the employees.

Please help with the logic.

Thanks in advance.

Regards,

Amrit

Output

Here is how you can do it.

Workflow:

1. Using summarize tool create list of unique dates.

2. Using append tool create combination of employees for each dates.

3. Using join multiple to do an outer join on Employee Name, Employee ID & Date. This adds the missing rows.

4. Using formula tool to replace nulls (new entries) with 8.

5. Using sort tool sort by date then by employee id.

Hope this helps : )