2 Replies Latest reply: Jun 28, 2013 5:19 AM by Stefan Koppejan RSS

    Split 1 hour record into 4 quarter records

    Stefan Koppejan

      Hi all,

       

      I have a problem, for a report I'm loading certain datavalues per hour:

       

      YearMonthDayTimeDescValue
      20136258:00:00testvalue28,31596

       

      I would like this to be 4 quarter (15 minutes) records with the same value, but I don't have a clue how to get this. I guess this must be done while loading in the script. This is the result that I need:

       

      YearMonthDayTimeDescValue
      20136258:00:00testvalue28,31596
      20136258:15:00testvalue28,31596
      20136258:30:00testvalue28,31596
      20136258:45:00testvalue28,31596

       

      The difference is in the Time field.

       

      Anyone can help me?

       

      Thanks in advance!

       

      Regards,

      Stefan