EmpAttendanceLogs:
LOAD
Uniqueid as EmpAttedenceLogID,
EmployeeUniqueId as EmpLogUniqueid,
Date(Floor(Num(AttendenceDate))) as EmpAttendenceLogDate,
AttendenceTime as EmpAttendenceLogTime,
attendence as EmpAttendenceLogDateTime,
IsRegularized
FROM
[..\10_data_sources\EmpAttendanceLogs.qvd]
(qvd);
Left Join (EmpAttendance)
Load
EmpLogUniqueid,
EmpAttendenceLogDate,
RegularizedStatus,
Date(Min(EmpAttendenceLogTime),'hh:mm:ss') as RegInTime,
Date(Max(EmpAttendenceLogTime),'hh:mm:ss') as RegOutTime
Resident EmpAttendance where IsRegularized=1
Group by EmpLogUniqueid,EmpAttendenceLogDate,RegularizedStatus;
Left Join (EmpAttendance)
Load
EmpLogUniqueid,
EmpAttendenceLogDate,
RegularizedStatus,
Date(Min(EmpAttendenceLogTime),'hh:mm:ss') as LogInTime,
Date(Max(EmpAttendenceLogTime),'hh:mm:ss') as LogOutTime
Resident EmpAttendance where IsRegularized=0
Group by EmpLogUniqueid,EmpAttendenceLogDate,RegularizedStatus;
My data model is something like this.
When i check for Sum with EmpAttendenceLogTime. It was showing correctly.
When i sum for RegInTime its showing double.
Please let me know if there is any mistake.
