Multiple Times Min/Max in Data Load

[kjeffries16]

Hello,

I am having trouble creating a flag with a field that a patient entered the room in between certain time blocks. The Surgeon has two different blocks of time 07:30-11:30 and 11:30-13:30.  I want to be able to see how many patients entered within the 07:30-13:30 timeframe for that particular day.  I've tried Min/Max with my SurgeonTimeKey without success:

I'd Like DailySurgeonStart to have 07:30 instead of 11:30 for the one block of time.                        

SurgeonTimeKey	BlockStartTime1	BlockEndTime1	BlockTimeKey	DailySurgeonBlockStart	DailySurgeonBlockEnd
12345	07:30	11:30	9871	11:30	13:30
12345	11:30	13:30	9872	11:30	13:30

Thanks for any help!

Kim

[Vegar]

I assume that in addition to this posted table you have a list of patients who entered containing the time of entry? Then you could do an interval match.

PatientEnteringData:
Load
PatientEnterTime,
PatientId,
Etc..
From PatientEnterData;

SurgeonBlocks:
Load SurgeonTimeKey,
BlockStartTime1,
BlockEndTime1,
BlockTimeKey
FROM SurgeonBlockData;

LinkTable:
Intervalmatch (PatientEnterTime)
LOAD BlockStartTime1, BlockEndTime1
Resident SurgeonBlocks;

Selecting the surgeonTimeKey 12345 will give you access to all patiens entered between 07:30 and 13:30.

PS: This will give you an synthetic key, but it is considered OK (some say "best practice") with a synthetic key when doing a interval match.