1 Reply Latest reply: Jun 19, 2014 5:53 AM by Mina Patel RSS

    Interval match question

    Mina Patel

      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?

        • Re: Interval match question
          Mina Patel

          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;