2 Replies Latest reply: Dec 2, 2012 12:06 PM by Dave Everaers RSS

    Split records - clock items per interval

    Dave Everaers
      Hi QlikView Guru's,
      I am wondering how i can split and calculate records in my load script.
      Example:
      I have two records like this:
      datetime starttime endtotal secondsemployee ID
      2012-12-0109:15:0011:15:007200101
      2012-12-0110:20:0012:20:007200265
      After loading this record I want this as output
      datetime starttime endtotal secondsemployee ID
      2012-12-0109:15:0010:00:002700101
      2012-12-0110:00:0011:00:003600101
      2012-12-0111:00:0011:15:00900101
      2012-12-0110:20:0011:00:002400265
      2012-12-0111:00:0012:00:003600265
      2012-12-0112:00:0012:20:001200265
      This way I can sum the total seconds per time interval.
      It would be great if someone can solve this puzzle.
      Thanks a lot for helping me out.
      Greetings, Dave