Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

Create a list box expression

and say

2013-11-08_1437.png

View solution in original post

3 Replies
rustyfishbones
Master II
Master II

Create a list box expression

and say

2013-11-08_1437.png

Not applicable
Author

Hah. I knew it would be something obvious.

Thank you!

marcus_sommer

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