topic Re: Extract the database tables used in the Qlikview script in QlikView

Extract the database tables used in the Qlikview script

alvinford — Mon, 13 Jul 2015 09:37:45 GMT

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.

Re: Extract the database tables used in the Qlikview script

Mon, 13 Jul 2015 10:04:13 GMT

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

avinashelite — Mon, 13 Jul 2015 10:07:54 GMT

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

marcus_sommer — Mon, 13 Jul 2015 10:09:13 GMT

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

- Marcus

Re: Extract the database tables used in the Qlikview script

Mon, 13 Jul 2015 10:09:17 GMT

Hi,

You can load Binary Load concept..

AT start of you script write,

Binary [anotherdocumentPath];

Re: Extract the database tables used in the Qlikview script

alvinford — Mon, 13 Jul 2015 12:12:03 GMT

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

marcus_sommer — Mon, 13 Jul 2015 12:24:29 GMT

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