Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dilmaraferreira
Partner
Partner

Automatically load multiple tables from a database

Good Morning,

Well, I am researching how to load several tables from a database (Oracle, SQL Server, Firebise and etc). However, I would like to know if you have a way to load an X number of tables through a loop, that is, you would not need to write several lines of code.

It would be possible? If so, an example or structure can be submitted. I checked several articles and they are based on Excel and QVD files, however the idea is to work with a database.

Thank you very much in advance

2 Replies
rwunderlich

Yes, you can use a loop.

If you know the tablenames you want to load, you can load the names into a table and iterate the table with either peek() or FieldValue(). 

If you want to discover what tables are in a database catalog, use the SqlTables script statement. 

-Rob

dilmaraferreira
Partner
Partner
Author

Would you have a script template? I found a way to load all the tables from a database. However, I will have problems because not all the loaded tables are necessary.

Model that bases me: https://community.qlik.com/t5/Qlik-Brasil/MySQL-to-QVD/gpm-p/1489476