3 Replies Latest reply: Apr 5, 2012 4:44 PM by Gary Strader

System Table Inquiry

Greg Crisman Apr 5, 2012 9:32 AM

Currently i'm trying to create an interface for my team that shows the system tables for a few apps. Now the system table generated automatically is halfway what we want, however, we were also hoping to include the qvd/txt/excel file that the fields are getting pulled from and/or possibly the qvd's the get created by each app. My question is this:

Is there a way to possibly set a variable, or is there a something already created such as $Field or $Table, that basically is a list of all the file names used to create the qvd?

Any help would be greatly appreciated. THANKS!!

System Table Inquiry

Jason Michaelides Apr 5, 2012 10:19 AM (in response to Greg Crisman )

I've recently started investigating using Tags for this but haven't got very far yet. Up to now I have manually updated a spreadsheet of all fields and tables (from $Field and $Table) and added the field "Source". Loaded this in as a data island as used it that way.

Hope this helps,

Jason
Like Show 0 Likes (0)

Actions
System Table Inquiry

Rob Wunderlich Apr 5, 2012 1:26 PM (in response to Greg Crisman )

You can load the soure linage data from the qvw itself. See the Meta Model group http://community.qlik.com/groups/meta-model-qv-power-tool
for more info.

-Rob
Like Show 0 Likes (0)

Actions
System Table Inquiry

Gary Strader Apr 5, 2012 4:44 PM (in response to Greg Crisman )

There is a metadata scanner utility somewhere on the community site. I wonder if this has the info you need.

Here it is: http://community.qlik.com/docs/DOC-1783
Like Show 0 Likes (0)

Actions

Go to original post