8 Replies Latest reply: Jun 8, 2016 3:06 AM by Gabor Tarnoczai Branched to a new discussion. RSS

    Qlik Sense Desktop: Load from path

    Jan-Hendrik Esterhuyse



      In Qlik Sense Desktop 0.96 I was able to load an excel file using a variable for the path


      let vFolderPath = 'C:\MasterFiles\';



      LOAD *

      FROM $(vFolderPath)MyFile.xlsx (ooxml, embedded labels, table is Sheet1);


      I upgraded to Qlik Sense Desktop 1.0.0 Build 21.ms8 and when I reload this now I get the following error message:


      LOAD statement only works with lib:// paths in this script mode


      So my question is:

      From Qlik Sense Desktop version 1 onwards, must you create a Folder Data Connection?


      Is there still a way to load a file using a FROM statement with a variable pointing to the path (rather than using a folder connection library). The reason I'm asking this is because when I share a app to another user I want to allow the user to simply change the path in the variable (use a trick or two for this to minimize user input) to allow that user to also load data from a file without having to edit the folder connection