topic Load all data from all tables in QlikView https://community.qlik.com/t5/QlikView/Load-all-data-from-all-tables/m-p/226668#M78837 <HTML><HEAD></HEAD><BODY><P>First, it depends on the database type - oracle, sql server, sybase, etc. Just google "find all tables in ...". After that, you have to loop through the tables selection all fields from each.<BR />Second, the reload will fail almost for sure because of the logical loops. You have to use QUALIFY to avoid this.</P></BODY></HTML> Wed, 28 Apr 2010 13:36:56 GMT Anonymous 2010-04-28T13:36:56Z Load all data from all tables https://community.qlik.com/t5/QlikView/Load-all-data-from-all-tables/m-p/226667#M78836 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I'm a bit rusty. I need to load all data from all tables in a database not knowing what the tablenames are. Is there a function to do this? Some like Load * from SysTables(0) ;</P><P></P><P>Regards,</P></BODY></HTML> Wed, 28 Apr 2010 13:03:15 GMT https://community.qlik.com/t5/QlikView/Load-all-data-from-all-tables/m-p/226667#M78836 2010-04-28T13:03:15Z Load all data from all tables https://community.qlik.com/t5/QlikView/Load-all-data-from-all-tables/m-p/226668#M78837 <HTML><HEAD></HEAD><BODY><P>First, it depends on the database type - oracle, sql server, sybase, etc. Just google "find all tables in ...". After that, you have to loop through the tables selection all fields from each.<BR />Second, the reload will fail almost for sure because of the logical loops. You have to use QUALIFY to avoid this.</P></BODY></HTML> Wed, 28 Apr 2010 13:36:56 GMT https://community.qlik.com/t5/QlikView/Load-all-data-from-all-tables/m-p/226668#M78837 Anonymous 2010-04-28T13:36:56Z