Re: Aggregation expressions required by GROUP BY clause
Let's go back a step and imagine what is going on in the Script Engine's head when it reaches this LOAD statement:
The Time() function accepts only one value as first parameter. For every possible combination of EmpLogUniqueId+EmpAttendanceLogDate+RegularizedStatus, you may get multiple different values in fields LoginTime, LogOutTime, RegInTime and RegOutTime. What should the Time() function do with these multiple values?
If you are sure that only one value is present in all fields, use Only() to simulate the use of an aggregation function, as in: