get first and last time at

[bsbernabe]

Hello There,

My concern is about how to get the first and last time Login and Logout.

Sample Data:

ID	TIME
125	8:00 AM
125	10:30 AM
125	4:00 PM
225	8:30 AM
225	9:00 AM
225	2:30 PM
225	5:30 PM

Supposedly this is what i want time display.

ID	TIME
125	8:00 AM
125	4:00 PM
225	8:30 AM
225	5:30 PM

Best Regards,

Bing

[MK_QSL · Accepted solution]

SET TimeFormat='h:mm TT';

Data:
Load *
Inline
[
 ID, TIME
 125, 8:00 AM
 125, 10:30 AM
 125, 4:00 PM
 225, 8:30 AM
 225, 9:00 AM
 225, 2:30 PM
 225, 5:30 PM
];

NoConcatenate
Final:
Load ID, Time(Min(TIME)) as TIME Resident Data Group By ID;
Load ID, Time(Max(TIME)) as TIME Resident Data Group By ID;

Drop Table Data;