Perhaps I misunderstand, but how do you associate a particular time-OUT with another time-IN for any given employee? In your data, sometimes you have time-OUT's with no apparent associated time-IN, and vice-versa. Maybe I am missing something, but is there some way you tie the time-OUT records to a specific time-IN record?
I put together an example where the date of the time-IN is used to associate with a time-OUT. I've attached QVW, and code is below.
TimeLog: Load *, empcode & Date(Date,'YYYYMMDD') As empkey; LOAD idcount, empcode, timecode, timelogs, Time, Date FROM TimeLog.qvd (qvd);
LogData: LOAD empcode, empcode & Date(Date,'YYYYMMDD') As empkey, timelogs As TimeIn Resident TimeLog WHERE timecode='F11';
Left Join Load empcode & Date(Date,'YYYYMMDD') As empkey, timelogs As TimeOut Resident TimeLog WHERE timecode='F12';
Drop Table TimeLog;
This assumes the time-OUT will always occur on the same day as the time-IN. If that is not so, then you'll either need another field to help associate the two events, or you could construct a model that assumes the time-IN's and time-OUT's are sequential (i.e., OUT always follows IN). But again, I see problems in the data with this. You sometimes have multiple OUT's with no apparent corresponding IN record, etc.
