topic questions regarding loading data from multiple sources in QlikView

questions regarding loading data from multiple sources

Wed, 19 Feb 2014 19:23:54 GMT

Hi There,

Recently I am working on building a report which requires data from different sources. Data is stored in different SQL Server and different Database. I am wondering how to load data located in 2 database by editing script.

Any response will be appreciated. Thank you so much!

Gloria

Re: questions regarding loading data from multiple sources

Gysbert_Wassenaar — Wed, 19 Feb 2014 19:28:38 GMT

Simply connect to the different databases in turn:

oledb connect to .... database1;

Table1:

sql select ... from ... ;

disconnect;

oledb connect to .... database2;

Table2:

sql select ... from ... ;

You can use the Connect... button on the Data tab in the script editor to define the connection. After creating the connection you can use the Select... button to create a statement to load data from the database you created the connection for.

Re: questions regarding loading data from multiple sources

Wed, 19 Feb 2014 19:53:52 GMT

Thank you so much for your reply. I have loaded data successfully!