Execute CommandLine string with Variable

[#1]

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

[kaushiknsolanki · Accepted solution]

Hi,

    Try this,

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

Let vPathFinal = 'c:\7za x' & $(vPath)

EXECUTE $(vPathFinal)

   Hope this will work

Regards,

Kaushik Solanki