4 Replies Latest reply: Jul 1, 2016 1:19 PM by Marcus Sommer RSS

    How to import a row of data from Excel into Qlikview

    Alec Whitaker

      Hello,

       

      I am trying to import a row of data from Excel into Qlikview. Unfortunately, I am unable to change the row (consisting of location ID #'s) to columns due to contractual reasons. I want to have this row of data be treated like a column, in that I want to be able to load it in as shown below so I can use it for reference with SQL Server.

       

      Row 10 has the ID's I need to be able to use to link the entries to the SQL data.

       

      The 'RowNo() = 10' shown below is not working on reading in Row 10. I would really appreciate any help in figuring out how to correctly write this statement to read in Row 10.

       

      LOAD D,
      E,
      F,
      G,
      H,
      I,
      J,
      K,
      RowNo() = 10

      FROM
      [Location]
      (
      ooxml, no labels, table is [table])
      WHERE RecNo() >= 11;

       

      Any help is greatly appreciated.

       

      Thanks,

       

      Alec