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)

    BAIKANG CHEN

      Hi:

       

      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

      JanFebMarAprMayJunJulAugSepOctNovDec
      Product A13323233535335086
      Product B52422434553389809
      Product C5623224453335808068
      Product D23423435235507806
      Product E4224255353335436806

       

      Qlikview Table:

      Product CodeDateSales
      Product A

      Jan

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