Extract the database tables used in the Qlikview script

[alvinford]

Hi ,

Would like to extract the only database tables used in the Qlikview script. (Dont want to extract the QVDs used in the same script)

Is there any application or script for that.

Regards,

Alvin.

[#2]

Hi,

You can use Add load statement for database tables and partial reload the files.

[avinashelite]

this need a script segregation of database and non data base table in the script and on the conditional set of the variables need to achieve this...but on the existing application I don't think   their is a direct option

[marcus_sommer]

What do you mean with "extract the only database tables ..." - I think you need to be more specific.

- Marcus

[#5]

Hi,

You can load Binary Load concept..

AT start of you script write,

Binary [anotherdocumentPath];

[alvinford]

Hi Thank You all for your replies.

Actually I need to get all the SQL Table Names used in the script.

How to achieve that.

Regards,

Alvin.

[marcus_sommer]

If you don't renamed your tables within the load you could use table- and fieldfunctions like tablename() to get the names of tables and something more, see: Re: TableName Function.

Further also the xml-header from the qvd' offers many informations, see the same link above by governance materials.

- Marcus