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.
Not applicable

Get Table list


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?

Tags (2)
1 Solution

Accepted Solutions
rustyfishbones
Honored Contributor II

Re: Get Table list

Create a list box expression

and say

2013-11-08_1437.png

3 Replies
rustyfishbones
Honored Contributor II

Re: Get Table list

Create a list box expression

and say

2013-11-08_1437.png

Not applicable

Re: Get Table list

Hah. I knew it would be something obvious.

Thank you!

Re: Get Table list

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;

next

-  Marcus

Community Browser