Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

oboute
New Contributor III

How to Export QVD files into QVS files with script

Dear experts,


I would like export QVD in QVS with script.


I know to export with the button "Export to Script File..."

But I need to export with batch files or directly in the QVD.

If you have solution for me


Regards,

Tags (1)
5 Replies

Re: How to Export QVD files into QVS files with script

It's not quite clear for me what do you want to do. The easiest way would be just to store the tables during the the load with something like this:

store Table into Table.qvd (qvd);

store Table into Table.csv (txt);

- Marcus

martinpohl
Valued Contributor II

Re: How to Export QVD files into QVS files with script

as Marcus wrote you can use the store command to store datas into txt-file.

store table into [lib:libname/filename,txt] (txt);

with this you can store one table into one file.

You can join tables, calculate fields or whatever you want in script and store the result in file.

As you wrote in the header:qvs is for script, although it is only a text-file, readable by any editor.

MVP
MVP

Re: How to Export QVD files into QVS files with script

Is it that you want to export the Script, rather than any of the data, to a file?

I seem to recall that rwunderlich‌ created something that could export the script, but I don't know if that can be triggered on a load.

See this thread for a discussion on it, and a link to download the extension:

How can I save a Qlik Sense Server script?

You could modify the extension, I suppose, so that it runs each time the extension is rendered rather than waiting for a button click - but you would still need to navigate to the sheet with the extension on it.

Hope that helps.

Luminary
Luminary

Re: How to Export QVD files into QVS files with script

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

oboute
New Contributor III

Re: How to Export QVD files into QVS files with script

Sorry for the late reply,

I don't want to store my data, but my script.

I'm going to look at Steve's post links

I will come to you when i find something

Thank you for your answers

Community Browser