Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to know about the underlying Datasrc,Datamart,Schema and tablename?

Hi all,

I have to document info regarding Datasrc,Datamart,Schema and tablename used in application. I have qvd files with me; how do I know about the info regarding Datasrc,Datamart,Schema and tablename associated with respective QVD file?

4 Replies
its_anandrjs

Hi,

In any table you can use the Show System Fields and use this fields to get the information about the association in the among the fields in the tables, also you can use the Ctrl + T view to get any ides which fields has association.

Regards

Anand

Not applicable
Author

My question is when I opened qvd file from qlikview;how do I know datasrc,schema and tablename from which data used in qvd is brought from?

when i cliked on cntl+t nothing is displayed and no system fields r displayed.


its_anandrjs

Hi,

In Qlikview try to open this QVD as the Xml then you can get its details source of the QVD creator No of fields and many more try this one.

Regards

Anand

Not applicable
Author

but i cud see only dsn i.e datasource name, there is no info about datamart and schema. How to get info regarding both?