Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

1 Solution

Accepted Solutions

Execute CommandLine string with Variable

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

1 Reply

Execute CommandLine string with Variable

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