topic Re: Get Table list in QlikView

Get Table list

Fri, 08 Nov 2013 14:31:03 GMT

I have over 400 tables and need to be able to programmatically get a list of the table names. (They change based upon field names associated with values within the database.)

How do I do this?

Re: Get Table list

rustyfishbones — Fri, 08 Nov 2013 14:48:48 GMT

Create a list box expression

and say

Re: Get Table list

Fri, 08 Nov 2013 14:51:56 GMT

Hah. I knew it would be something obvious.

Thank you!

Re: Get Table list

marcus_sommer — Fri, 08 Nov 2013 14:55:24 GMT

In gui you could use the system-fields in various objects, there is for example an own object structure table. In script you could use table- and field-functions in a loop:

for i = 1 to nooftables() - 1

Tables:

Load i as nr, tablename(i) as Table autogenerate 1;

- Marcus