Discussion Board for collaboration on QlikView Scripting.
I can call the Winrar to compress (.rar or .zip) my files (most .csv) in qlikview script?
Winrar has a built-in console version.
You can execute whatever you want from the script.
Look for 'exec' command in QV help.
Try use Execute
With the Execute statement it is possible to run other programs during the re-execution of the QlikView
script, e.g. conversions that are necessary.
The syntax is:
commandline is a text that can be interpreted by the operating system as a command line.
Execute C:\Program Files\Office12\Excel.exe
I tried using the command, but it seems that he can not find the file to be compressed.
As I understand it, the EXECUTE simulates an execution in Prompt, then it would be something like this?
LET WinrarFolder = 'C:\Program Files (x86)\WinRAR\WinRAR.exe';
EXECUTE $(WinrarFolder) $(FilesToCompressPath\*.*) a / * parameter WinRAR to compress * / $(DestinationFolder)
Is this correct?
EXECUTE $(WinrarFolder) $(FilesToCompressPath\File) $(DestinationFolder)
First test your statement in cmd and then use in Qlikview.
You can't debug the syntax of EXECUTE command inside Qlikview.