Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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?