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],ShiftNameInline [EventStart, EventEnd, ShiftName06:00, 13:59, MO_Shift114:00, 21:59, MO_Shift222: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;