A client requested if it is possible to develop a QlikView report using more than one data source at the same time. In other words, the client has some data, let's say, in a production database, and some other data sitting in an Excel, and wants to generate a report that uses both data sources at the same time.

What are the different options that could be used if any (native in QlikView or work arounds)?

As a follow up to my original question and to give mode requirements details...

Let's assume we have an existing QlikView script that pulls data from an Oracle database as follows:

ODBC CONNECT TO [my_oracle_database];

Tab1:Load f1,f2,f3;SQLSELECT f1,f2,f3 FROM my_db_table;

Now, let's assume that we have additional data that need to be included in our report.This additional data though is not in my Oracle database but rather some of it is in a MS Access (Northwind.mdb)and some of it is in Excel file (draft.xls).

Per the QlikView Reference Manual, the script can be modified as follows to combine all 3 data sources:

// Point to my Oracle database firstODBC CONNECT TO [my_oracle_database];// All selects from here on will get data from oracle database my_oracle_database

Tab1:Load f1,f2,f3;SQLSELECT f1,f2,f3 FROM my_db_table;

// Point to MS Access secondConnect to 'Nwind;DBQ=C:\ProgramFiles\MSOffice95\Access\Samples\Northwind.mdb' (UserID is sa, Password is admin);// All selects from here on will get data from MS Access Northwind.mdb

Tab1:// Using add to merge new selected records to the previous records in Tab1addLoad f1,f2,f3;SQLSELECT f1,f2,f3 FROM my_db_table_in_ms_access_Northwindmdb;

Tab1:// Point to MS Excel third// Using add to merge new selected records to the previous records in Tab1addLoad f1,f2,f3FROM [C:\draft.xls] (biff, embedded labels, table is [SQL Results$]);

Please let me know if this makes sense overall; and also if there are better ways to do it. For example, should concatenate be used instead of add? Etc.