6 Replies Latest reply: Aug 30, 2017 3:32 AM by Staffan Johansson RSS

    create min&max timestamp

    Staffan Johansson

      Hi,

       

      I have problem to create min and max timestamp. My rawdata looks like this.

      expected below, I can not use a min and max and do a Group by on Dimension because all dimension will be repeated.

      This has to be done in the load script.

         

      dimensionminmax
      44-1502017-08-25 11:00:002017-08-25 11:01:59
      50-1002017-08-25 11:02:592017-08-25 11:05:59
      63-1252017-08-25 11:06:592017-08-25 11:08:59
      50-1002017-08-25 11:09:592017-08-25 11:10:59
      63-1252017-08-25 11:11:59

      2017-08-25 11:13:59