1 Reply Latest reply: Jun 24, 2011 3:36 PM by Kaushik Solanki RSS

    Execute CommandLine string with Variable

      Is it possible to execute a commandline with a variable in the string?  I am looking at whether QlikView can handle scheduling a daily unzip and load.  I need to be able to dynamically define the filename (which I have no control over) to extract the daily zip file that is being dropped into a FTP folder.

       

      Example:

       

      Let vYesterday = Today() - 1;
      Let vPath = '\\Server\Folder\transaction_' & Date(vYesterday, 'YYYYMMDD') & '000105_2155.csv.zip';

       

      EXECUTE c:\7za x vPath

       

      The result should be a commandline like

       

      EXECUTE c:\7za x \\Server\Folder\transaction_20110624000105_2155.csv.zip

       

      Thanks for your help!

      Scott