topic Batch for emptying the file in QlikView

Batch for emptying the file

Danijel — Wed, 25 Nov 2020 16:16:04 GMT

Hello togehter,

i want to write a batch, which can do the following:

- copy the file to folder X
- Remove all data

Copying is not a problem, but emptying it. There is a command "/nodata" but the QlikView instance remains open. I would still need a command to save and close the file.

Does anyone know of such a possibility?

Thanks

Greetings.

Re: Batch for emptying the file

Vegar — Mon, 27 Apr 2020 09:34:44 GMT

Maybe you can accomplish this utalizing the PRJ folder functionallity in QlikView. To automate you could probably create a batch job that triggers @rwunderlich PRJ-tool. I haven't tried this tool my self, but Rob Wunderlich tools usually does what they say they do.

Good luck.

Re: Batch for emptying the file

rubenmarin — Mon, 27 Apr 2020 10:14:43 GMT

Hi, I haven't tested but with /v parameter you can pass a variable value to a reload.

At start of script the variable value can be checked, if it's the backup value then exit script, so instead of open with /nodata you launch a reload that doesn't loads anything.

"C:\Program Files\QlikView\qv.exe" /R "Path\Document.qvw" /vvBackup='Y'

And script starts with:

IF '$(vBackup)'='Y' THEN Exit Script; ENDIF // Normal script