Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
Create a list box expression
Hah. I knew it would be something obvious.
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
Load i as nr, tablename(i) as Table autogenerate 1;