3 Replies Latest reply: Jan 24, 2018 10:50 AM by Krzysztof Tyrakowski RSS

    Table transpose

    Krzysztof Tyrakowski

      Hello QV Experts,

       

      I have encountered quite challenging task. The issue is as follows:

      I need to transform below table (in the script, I need qvd files with the below table and the new one)

      IDTaskStartTimeEndTimeEndTime-StartTime [h]
      01A11:0012:001
      01B11:3013:302
      01C11:1512:151
      02A11:3014:303
      02B10:4012:402
      02C11:0012:001

       

      As a result I need to create table as below:

       

      IDA.StartTimeA.EndTimeB.StartTimeB.EndTimeC.StartTimeC.EndTimeA.EndTime-StartTime [h]B.EndTime-StartTime [h]C.EndTime-StartTime [h]
      0111:0012:0011:3013:3011:1512:15121
      0211:3014:3010:4012:4011:0012:00321

       

       

      I have more than 300 000 record in the first table so the problem may be also performance of the script execution

      I would appreciate any help how to achieve the final result

      The transformation looks like kind of "reverse crosstable", but nothing comes to my mind to make it

       

      Thank you in advance for your support/comment

      Krzysztof