5 Replies Latest reply: Sep 7, 2017 1:19 PM by Paul Sparrow RSS

    read in data from folder

    Paul Sparrow

      Trying to read in data from multiple files in a folder.  In QlikView I did a loop to grab file names and then looped to grab the data.  QlikSense needs to create connections by the looks of it.  Is there a way to grab all file information under a folder?

       

      Tried this and it didn't work:

       

      LOAD

          *

      FROM [lib://EBIFiles/*.xlsx]

      (ooxml, embedded labels, header is 1 lines, table is Main);