6 Replies Latest reply: Jun 7, 2011 7:20 AM by Anne Duffy RSS

    Transpose  Excel in script load

      Hi Guys,


      Hope someone can help, I am in the middle of loading Excel management reports into Qlikview,


      There are a few that are formatted incorrectly , at the moment they are formatted like FIG 2 , however I wish for them to be formatted as FIG 1 .


      ( Basically all the data Transposed !!) I dont really want to do this in Excel (as the management do not want their logs amended and I'm not really keen on building a mirror log to load)


      Doen anyone know if Qlikview has some fancy script that may help ?





      FIG 1

      Test v3.bmp



      FIG 2

      test 1v2.bmp