4 Replies Latest reply: Apr 29, 2015 8:20 AM by Daniel Oberbillig RSS

    Transformation help!

    Ganesh Reddy

      Hi all,

       

      How to find valid meal break, first meal time out and second meal time out from below given data,

      Ex: 22:15:00-24:00:00|dayDivide|00:00:00-02:30:00|Break|03:00:00-06:46:00.

       

       

       

      LOAD * INLINE [

          Punches

          22:15:00-24:00:00|Break|00:00:00-02:30:00|Break|03:00:00-06:46:00.

          00:00:00-02:51:30|Break|03:23:00-04:00:00|Break|04:30:30-12:07:00

          00:00:00-03:30:00

          00:00:00-02:51:30|Break|03:23:00-04:30:00

          00:00:00-05:30:00

      ];

       

      From the above data how to get these fields valid meal break, first meal time out and second meal time out.

       

      Cheers,

      Ganesh