topic Find QVW That Created A QVD in QlikView

Find QVW That Created A QVD

rebelfox — Thu, 28 May 2015 07:46:01 GMT

I have inherited a huge folder full of QVW's and QVD's

Is there a way of finding out which QVW created a QVD without buying a tool to look in a QVD?

Thanks

Re: Find QVW That Created A QVD

PrashantSangle — Thu, 28 May 2015 07:53:48 GMT

Hi,

Create a new QVW -> Go to Edit Script->Table Files->Load QVD->Then you will get pop of File Type Wizard->select xml->Finish->Reload it .

Then You get field Creator Doc which give you QVW of QVD file.

Regards

Re: Find QVW That Created A QVD

Colin-Albert — Thu, 28 May 2015 08:04:35 GMT

open the QVD file in a text editor, notepad will do, and you can see which qvw was used to create the file in the <CreatorDoc> tag.

Re: Find QVW That Created A QVD

Peter_Cammaert — Thu, 28 May 2015 08:06:24 GMT

Just try it yourself. Every QVD contains a header in XML, filled with all sorts of interesting details. One of the tags in this header is <CreatorDoc> which specifies the name of the document that last created this QVD. The XML header can be read into a QVW with an appropriate LOAD statement. Or if it's just a single shot, open your QVD in Notepad++ or any other text editor that isn't afraid of large files, and jump straight to the end.

You could try the Governance Dashboard which does all of that for you. However, this dashboard is targetting larger environments and may prove a bit costly to set-up and use for one source document only.

Peter

Re: Find QVW That Created A QVD

rebelfox — Thu, 28 May 2015 08:45:17 GMT

Thanks - all good info

Re: Find QVW That Created A QVD

rebelfox — Thu, 28 May 2015 08:45:49 GMT

Thanks for your help