topic Re: Need metadata of tables in QlikView

Need metadata of tables

Mon, 30 Nov 2015 14:16:12 GMT

Hi,

I need metadata of loaded tables, like number of rows, no of columns, type of data either numeric or character, number of nulls in table. Please help me if we can write some function or some way to get this information out of table.

Regards,

Navdeep

Re: Need metadata of tables

Gysbert_Wassenaar — Mon, 30 Nov 2015 14:18:15 GMT

Open the Document Properties window and look at the information on the Tables tab. For individual fields you can add Statistics Box objects and add the information items you want to see for that field.

Re: Need metadata of tables

marcus_sommer — Mon, 30 Nov 2015 14:23:45 GMT

Quite helpful is also the structure-table (last item by right-click and choosing of new object) with the use of the system-fields.

- Marcus

Re: Need metadata of tables

magavi_framsteg — Mon, 30 Nov 2015 14:24:53 GMT

Hi navdeep kumar.

This metadata, except data types and null counter, is extracted in Qlik Deployment Framework.

The app is called IndexMonitor.qvw.

You are free to amend it to pick up what else you require, like null counter and data types.

Re: Need metadata of tables

Mon, 30 Nov 2015 14:59:35 GMT

Hi All,

I need output in cvs/txt file having no of rows/no of columns/null values/data type of each column.

Thanks,

Navdeep

Re: Need metadata of tables

Mon, 30 Nov 2015 15:00:25 GMT

I want in report form for each field in table, please suggest some way.

Re: Need metadata of tables

Mon, 30 Nov 2015 15:02:14 GMT

I will keep it as last resort, please suggest me some solution which we can use and create report kind of thing.

Re: Need metadata of tables

Mon, 30 Nov 2015 15:10:27 GMT

Please point me to the link where I can find IndexMonitor.qvw.

Re: Need metadata of tables

magavi_framsteg — Mon, 30 Nov 2015 15:24:27 GMT

Hi.

It is in the default installation of QDF.

I'm sure you will find it, just search for it.

Sent from localhost.com<http://localhost.com> (127.0.0.1)

Re: Need metadata of tables

marcus_sommer — Mon, 30 Nov 2015 15:27:08 GMT

You could export such a structure-table - here: Re: Chart with count of $Field values you could find a very sophisticated solution from rbecher. Also possible is it to create those informations with table- and field-functions within the script: Re: Save All Field Names In New Table - but both solutions are not fast by large applications and a reducing to the realy needed topics is necessary.

Further you could read the xml-metadata from a qvw and/or the layout-export to get a lot of informations from them. For this you should look to various tools which already exists:

http://community.qlik.com/blogs/technicalbulletin/2013/12/05/qlikview-governance-dashboard-11-available-for-download

Governance Materials.zip‌

- Marcus

Re: Need metadata of tables

Kushal_Chawda — Mon, 30 Nov 2015 15:41:32 GMT

When you load the QVDs using table file select the option xml. There you can see the meta data about your QVD file loaded. You can load this meta data into the separate QVD by store command