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.
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!