Extracting metadata

There are a number of ways of extracting metadata from our QlikView applications, and some are easier than others.

Note

The Governance Dashboard (as explained later) extracts metadata and imports log information into a good application to manage your data. However, another tool that I really recommend to use to look at metadata and the details of the document is Rob Wunderlich's Document Analyzer (http://robwunderlich.com/downloads/).

Exporting the structure

Structure exporting is a facility that has existed in QlikView for many versions—we can export the data structure information into tab-delimited text files.

In the Tables tab of Document Properties, there is an Export Structure button.

This will export three files—table information, a mapping table from tables to fields, and field information:

These tables can be read into another QlikView file for analysis.

Extracting from QVD files

A QVD has an XML header that we can easily read into a QlikView document...