Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
alvinford
New Contributor III

Extract the database tables used in the Qlikview script

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.

6 Replies
Not applicable

Re: Extract the database tables used in the Qlikview script

Hi,

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

Re: Extract the database tables used in the Qlikview script

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

Re: Extract the database tables used in the Qlikview script

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

- Marcus

Not applicable

Re: Extract the database tables used in the Qlikview script

Hi,

You can load Binary Load concept..

AT start of you script write,

Binary [anotherdocumentPath];

alvinford
New Contributor III

Re: Extract the database tables used in the Qlikview script

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.

Re: Extract the database tables used in the Qlikview script

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

Community Browser