load multiple tables in a single load statement

Wed, 17 Jun 2015 13:09:17 GMT

Hi Good Evening,

Could you please answer me any one.

How to load multiple tables in a single load statement?

Re: load multiple tables in a single load statement

sinanozdemir — Wed, 17 Jun 2015 15:36:11 GMT

It is a vague question, but I will do my best to elaborate:

If you are pulling data from a SQL database, you can pick ODBC (is strictly for relational databases) or OLE DB (is not strictly for relational databases, it is for SQL, Access and Excel files as well). Once you choose an ODBC connection, you click "Select" to start building your SELECT statement. If you want to pull data from a different server/database, you follow the same steps.

For Excel files, you can use "Table Files" options, as many times as you would like to import Excel files from different directories on your computer.

topic load multiple tables in a single load statement in QlikView

load multiple tables in a single load statement

Re: load multiple tables in a single load statement