topic Multiple Times Min/Max in Data Load in App Development

Multiple Times Min/Max in Data Load

kjeffries16 — Sat, 16 Nov 2024 05:40:38 GMT

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

Re: Multiple Times Min/Max in Data Load

Vegar — Mon, 03 Jun 2019 19:23:24 GMT

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.