Get start and end time from time list per day

[#1]

Hi Guys,

We have time registration per user as below screenshot (user names removed from column A).

The screenshot example is all same user, with data for one week.

How can I get the min and max time per user per day?

Thank you,

Michiel

[Miguel_Angel_Baeyens]

Hello Michiel,

As far as I understand, you only want to keep two lines for every user:

Aggr(Max(ScanTime), UserName)

Should return the maximum value of field ScanTime per username. You can add more fields depending on the aggregation you want to get.

Hope this helps.

[#3]

Hi Miguel,

Yes you are right and the result is good but I prefer to do it in script and AGGR is not an accepted function in script.

Could you hint me how to do this in script ? the final should be to calculate work hours per day per user in script.

Thank you~

[Miguel_Angel_Baeyens]

Hello Michiel,

If doing that in the script is a requirement, you can do something like

Table:LOAD UserName, Max(ScanTime) AS MaxScanTimePerUserFROM FileGROUP BY UserName;

Although similar, it's not SQL syntax.

Hope that helps.

[#5 · Accepted solution]

Hi Miguel,

Thank you, this is what I aksed for, especialy the "Group BY" worked very nice.