Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
qlikwiz123
Contributor

QVX to QVDs

 

I just started using Qlikview and I have a bunch of qvx files in a folder directory. How do I convert all of them to individual qvds?


More precisely,  File1.qvx,File2.qvx...... to File1.qvd, File2.qvd.....

Labels (2)
3 Replies
Partner
Partner

Re: QVX to QVDs

If you want to convert you could load the file into QlikView and store it into qvd, something like this.

For each vFile in 'File1','File2', 'File3'
[$(vFile)]:
Load *
From
[C:\FolderPath\$(vFile).qvx] (qvx);
Store [$(vFile)] into [$(vFile).qvd] (qvd);
Drop table [$(vFile)];
Next
Please ekskuse my Norglish and Swenglish typos.
qlikwiz123
Contributor

Re: QVX to QVDs

Thank you so much. What happens if I have 20-30 qvx files that keep changing? It becomes redundant to write all the file names in "For each vFile in" line. Any way to automate this process where the script looks for the files and generates QVDs with the same file names
Partner
Partner

Re: QVX to QVDs

 

For each vFile in filelist('C:\FolderPath\*.qvx')
...
Next
Please ekskuse my Norglish and Swenglish typos.