Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

To get tables list before tables load

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. 

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: To get tables list before tables load

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 

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

Re: To get tables list before tables load

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

Highlighted
Creator II
Creator II

Re: To get tables list before tables load

Loading from qvd and/or sql.

Highlighted
Creator III
Creator III

Re: To get tables list before tables load

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 

View solution in original post

Highlighted
Creator II
Creator II

Re: To get tables list before tables load

Usefull advice. Thank you much.