Execute CommandLine string with Variable

Fri, 24 Jun 2011 18:50:14 GMT

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

Execute CommandLine string with Variable

kaushiknsolanki — Fri, 24 Jun 2011 19:36:57 GMT

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

topic Execute CommandLine string with Variable in QlikView

Execute CommandLine string with Variable

Execute CommandLine string with Variable