topic How to display the metadata information? in QlikView

How to display the metadata information?

Anonymous — Wed, 22 Oct 2014 10:13:14 GMT

Hi ,

I need to display the metadata information as a table in the Welcome page (One of the rows in the table could be as below)

1. Data source---Excel File( From where the table data has been added as a row)

2.Data Last Loaded --- particular date.and time.and day if it is possible.

Many thanks ,

Sharma.

Re: How to display the metadata information?

Wed, 22 Oct 2014 10:22:19 GMT

Hi,

We have the functions like

Documentname() for document name and reloadtime() for last reloaded time.we need to have the tables list so we can enable system fields in that fields we have tables,it has all the table names in a list box

Re: How to display the metadata information?

Anonymous — Wed, 22 Oct 2014 10:27:55 GMT

Hi Rakesh ,

Thanks for the reply but i didnt understand ".we need to have the tables list so we can enable system fields in that fields we have tables,it has all the table names in a list box."

Regards,

Sharma

Re: How to display the metadata information?

rustyfishbones — Wed, 22 Oct 2014 10:33:27 GMT

Create an ODBC Connection to the Excel file, something like

ODBC CONNECT32 TO [Excel Files;DBQ=C:\Users\Alan.PRINCIPAL\Desktop\Budgets\2011.xlsx];

tables:

SQLTables;

DISCONNECT;

This will give you a list of the Excel Tables or sheets

Re: How to display the metadata information?

ashfaq_haseeb — Wed, 22 Oct 2014 10:37:15 GMT

Hi,

Check if this helps

Regards

ASHFAQ

Re: How to display the metadata information?

Anonymous — Wed, 22 Oct 2014 10:45:58 GMT

Hi Alan,

Thanks for the reply But i am wondering how would i display as a metadata table in the homepage.

Regards,

Sharma

Re: How to display the metadata information?

Anonymous — Sun, 26 Oct 2014 15:01:43 GMT

Excellent solution