2 Replies Latest reply: Dec 8, 2015 10:04 AM by Łukasz Liziniewicz RSS

    Loading with transposition

    Łukasz Liziniewicz

      Dear QV Masters,

       

      I have such data in my database:

         

      PERIODPARTNERDIM_1DIM_2DIM_3
      201301P_011917
      201301P_0221018
      201302P_0131119
      201302P_0241220
      201303P_0151321
      201303P_0261422
      201304P_0171523
      201304P_0281624

      I would like to transform data to the table:

         

      PERIODPARTNERDIMVALUE
      201301P_01DIM_11
      201301P_02DIM_12
      201302P_01DIM_13
      201302P_02DIM_14
      201303P_01DIM_15
      201303P_02DIM_16
      201304P_01DIM_17
      201304P_02DIM_18
      201301P_01DIM_29
      201301P_02DIM_210
      201302P_01DIM_211
      201302P_02DIM_212
      201303P_01DIM_213
      201303P_02DIM_214
      201304P_01DIM_215
      201304P_02DIM_216
      201301P_01DIM_317
      201301P_02DIM_318
      201302P_01DIM_319
      201302P_02DIM_320
      201303P_01DIM_321
      201303P_02DIM_322
      201304P_01DIM_323
      201304P_02DIM_324

      Is there any simple way to do this?