topic Re: SQL Script from .QVD file in QlikView

SQL Script from .QVD file

Anonymous — Thu, 14 Apr 2016 16:26:37 GMT

It is possible to use SQL Script to extract information from .QVD files?

ExampleTable:

SELECT A, B, C

FROM

(qvd);

Something like this...

Thank you so much!

Re: SQL Script from .QVD file

sunny_talwar — Thu, 14 Apr 2016 16:45:02 GMT

Not sure if you want to do just this:

ExampleTable:

LOAD A,

FROM

(qvd);

Re: SQL Script from .QVD file

Gysbert_Wassenaar — Thu, 14 Apr 2016 16:45:49 GMT

No. A qvd file is simply a binary file with memory dump of a table from a qlikview or qlik sense document. It is not an SQL database management system. You load data from a qvd in Qlikview or Qlik Sense with the LOAD statement.

ExampleTable:

LOAD A, B, C

FROM

(qvd);

Re: SQL Script from .QVD file

jlongoria — Thu, 14 Apr 2016 18:22:05 GMT

I'm going out on a limb with this post. If you are interested in reading information about the QVD file (metadata) not the contents of the QVD file itself then the link below should help. If not. . .what they said.

How To Read Meta Data From A QlikView QVD