24 Replies Latest reply: Jul 3, 2018 3:19 AM by Andy Manuja RSS

    Creating a variable for the folder path

    Andy Manuja

      Hi,

       

      I want to create a variable for the folder path so that, I could easily shift from one computer to another just changing the actual file path only in the variable statement.

      I have seen the function of "SET" can be used to set the variable path for the folder the file is located (the file can be an excel file or a QVD file).

       

      Find below the script to load the data in to qlik sense.

       

      Temp1:

      LOAD

          Prod_ID,

          Prod_Name,

          Quantity,

          Country,

          If(Country='NZ',1,0) as Flag1

       

      FROM [lib://Andy (XXX)/Data\Sales_Data\Products.xlsx]

      (ooxml, embedded labels, table is Products);

       

      Could anyone provide a solution to accomplish the above said task since I tried some methods using SET function but did not give me the expected results.

       

      Thanks in advance.

       

      Kind regards,

       

      Andy