Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using interval match to create a shift pattern log, but now I have another request where I have three different warehouse all with different shifts how can I separte the warehouses, becuase you can only use one field for intervalmatch.
Any ideas?
my code look like this
LOAD
time#(Start)as [EventStart],
time#(End) as [EventEnd],
ShiftName
Inline
[
EventStart, EventEnd, ShiftName
06:00, 13:59, MO_Shift1
14:00, 21:59, MO_Shift2
22:00, 06:00, MO_Shift3
];
ShipmentsLog:
LOAD
[Details.Creation Timestamp],
time([Details.Creation Timestamp]) as EventTime,
[Details.Last Modified Timestamp]
FROM
[Details.qvd]
(qvd);
Data:
IntervalMatch(EventTime)
Load
[EventStart], [EventEnd]
resident Shifts;