4 Replies Latest reply: Jun 3, 2014 2:24 AM by BAIKANG CHEN RSS

    Loading A Two Dimension Excel File (with a dimension on the top)



      I am wondering is it possible to transfer a two dimension Excel file with one dimension on the top to a two dimension table with all dimensions on the left when loading in the script.


      Thank you very much.


      Here is an example


      Excel File

      Product A13323233535335086
      Product B52422434553389809
      Product C5623224453335808068
      Product D23423435235507806
      Product E4224255353335436806


      Qlikview Table:

      Product CodeDateSales
      Product A


      Product AFeb3
      Product AMar3
      Product AApr23
      Product ADec6
      Product BJan5
      Product BFeb2
      Product BDec9