4 Replies Latest reply: Jul 20, 2015 9:55 PM by arjun rao RSS

    how to create a loop to automatically upload excel file into Qlikview

      Hello,

       

      I will like to automatically load an excel file that changed every year into qlikview.  This year file is called " Listing2015 ", next year will be Listing2016 etc.. and I will like qlikview to automatically grab the data for the most recent year.

      The file is saved on a network drive.

       

      Listing:
      LOAD Property,
      Owner,
      Auditor,
      VP,
      RPM

      FROM
      [\\172.65.58.19\THEDRIVE\LISTING\Traore\LIST\Listing 2015.xlsx]
      (
      ooxml, embedded labels, header is 5 lines, table is [Listor]);

       

       

      Any help will be appreciated