To get tables list before tables load

[Peony]

Hi.

Is there any possibility to get  tables names list from the document before tables will bee loaded?

Usually, to get table list I will do somethig like that in the load script:

Table1:
Load * From Table 1;

Table2:
Load * From Table 2;
...

TableN:
Load * From TableN;

For i = 0 to NoOfTables() - 1Tables:
Load
TableName($(i)) as [Table name]
Autogenerate 1;

Next i;

And as the result I will get a liast of table names:

Table name
Table1
Table2
...
TableN

But if it was possible to get such list without tables full load. 

[miskinmaz]

It depends from where you are pulling the table. Can you specify the source.

[Peony]

Loading from qvd and/or sql.

[miskinmaz · Accepted solution]

If from qvd then you can try to use filelist and filename function  of qlikview. Filelist helps you to get all the files from a directory and filename return the name of the file in that particular directory.

Whereas in SQL system tables stores all the information related to a schema, so can try to use those system table to get the names of tables 

[Peony]

Usefull advice. Thank you much.