2 Replies Latest reply: Jul 3, 2014 4:07 AM by Juan Pedro Hidalgo RSS

    Load from an Crosstable formatted Excel

    Juan Pedro Hidalgo

      Hello everyone,

       

      i need to load an excel file that is formatted this way into qlikview:

       

      janfebmaradjustment
      Customer1unit price101010
      Customer1budget100
      Customer1rolling 11050
      Customer2unit price202020
      Customer2budget200
      Customer2rolling250

       

      Is the first time i try to import this kind of data. I need them to be load in a linear way like:

       

      CustomerMonthMetricValue
      Customer1JanUnit Price10
      Customer1febUnit Price10
      Customer1janBudget100

       

      Any idea's on how to achive this result?

       

      Thanks and best regards,

      Juan Pedro