2 Replies Latest reply: Dec 27, 2012 8:11 AM by Domingos Santin Neto RSS

    Setting a Variable in "LOAD" in Scripts

      Hello,

       

      My data sources change monthly, and all are excel files with "YY-MM" at the end of the file name, so to make it easier to change those references, I'd like to set two variables, like this:

       

      Set FilePath='C:/Path' //Just an example

      Set Ref='AA-MM' //With YY being current year and MM last month, i.e.: 12-11

       

      I'd then use this variables in LOAD field of my sources, like:

       

      [Example]:

      LOAD Data1,

           Data2

      FROM FilePath&'FileName'&Ref&'.xls' (ooxml, embedded labels, header is 1 lines, table is DATA);

       

      Instead of:

       

      [Example2]:

      LOAD Data,
           Data2

      FROM [C:\Path\Base_12-11.xls]
      (biff, embedded labels, header is 1 lines, table is DATA);

       

      However, this does not seem to work, as Qlikview searches for the root folder of my .qvw file first instead of going to FilePath. Is there any way to do this?