Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
Is anyone knows how to find the qlikview program that created a qvd file ???
Maybe a tool exist ??
Thank you for your help !!
Hi Thierry, there is a xml meta-data header inside the QVD that states what qvw file that created the qvd. You can load in the meta-data into QlikView by choosing to load xml data but point to the qvd file. You can also open the qvd with an editor and inspect the xml header as shown below, the qvw file that generated the qvd is in blue.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<QvdTableHeader>
<QvBuildNo>12742</QvBuildNo>
<CreatorDoc>Z:\3.AcmeSales\1.Application\1.QVD-Generator-example\QVD-Generator-Example.qvw</CreatorDoc>
<CreateUtcTime>2015-04-28 17:23:21</CreateUtcTime>
<SourceCreateUtcTime></SourceCreateUtcTime>
<SourceFileUtcTime></SourceFileUtcTime>
<SourceFileSize>-1</SourceFileSize>
<StaleUtcTime></StaleUtcTime>
<TableName>Customers</TableName>.....
Best regards
Magnus
you can use below functions in QlikView Script to check whether qvd exists or not
Use them in LOAD statement
QvdCreateTime
or
FileSize
I know these functions, but they aren't useful here. In fact, we have some qvd files that we can't remember in which qvw they have been created..
Hi Thierry, there is a xml meta-data header inside the QVD that states what qvw file that created the qvd. You can load in the meta-data into QlikView by choosing to load xml data but point to the qvd file. You can also open the qvd with an editor and inspect the xml header as shown below, the qvw file that generated the qvd is in blue.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<QvdTableHeader>
<QvBuildNo>12742</QvBuildNo>
<CreatorDoc>Z:\3.AcmeSales\1.Application\1.QVD-Generator-example\QVD-Generator-Example.qvw</CreatorDoc>
<CreateUtcTime>2015-04-28 17:23:21</CreateUtcTime>
<SourceCreateUtcTime></SourceCreateUtcTime>
<SourceFileUtcTime></SourceFileUtcTime>
<SourceFileSize>-1</SourceFileSize>
<StaleUtcTime></StaleUtcTime>
<TableName>Customers</TableName>.....
Best regards
Magnus
That's it !!!
Thanks a lot.
I had to guys.
Regards,
Mike T
Qlik