4 Replies Latest reply: Apr 25, 2010 9:01 AM by Oliver Demus RSS

    duplicate (one time or multiple times) row (with CONCATENATE)

      Hello Users,

      I have the following questions

      I want to load the following data set
      Date Time Duration[in h]
      1/1/2010 7:00PM 10

      In the attached file, the result is
      Date FromTime ToTime Duration[in h]
      1/1/2010 7:00PM 11.59PM 5
      1/2/2010 12:00AM 5:00AM 5

      But I don't have an idea to get to this
      Date Time Duration[in h]
      1/1/2010 7:00PM 50

      In the attached file, the result is
      Date FromTime ToTime Duration[in h]
      1/1/2010 7:00PM 11.59PM 5
      1/2/2010 12:00AM 11.59PM 24
      1/3/2010 12:00AM 9.59PM 21

      I can't get it to work, can somebody help me out with this?

       

      Thanks in advance,

      Oliver