8 Replies Latest reply: Jun 8, 2016 3:06 AM by Gabor Tarnoczai RSS

    Qlik Sense Desktop: Load from path

    Jan-Hendrik Esterhuyse

      Hi

       

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

       

      let vFolderPath = 'C:\MasterFiles\';

       

      Table1:

      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