Multiple databases connect for dashboard

[#1]

Hi,

I am creating dashboard from two databases, I created ODBC connection for one DB and its connected fine. I pulled table called Master.

In the second tab, I connected another ODBC connection for another DB and its connected fine. I would like to pull the same table called Master.

And wanted to union these two tables as both tables same kind of fields, First of all is it possible to do that? How can I find the Master is coming from first DB or second DB.

Pls let me know your valuable inputs.

Thanks,

[#2]

So are you suggesting me to reload the script and get the field names from the table objects and copy it in the script.

There is no option where I can pick the required fields before run the dashboard?

Thanks,

[SunilChauhan]

it will only come when you create connection string

using Oledb

and after that when you selecting Data from dB using Select in qlikview

it will show you to check option for Preceeding load

hope this helps

[#4]

The Syntax Grossi and Jagan are not working and not showing the table names separately.

Pls let me know the best syntax.

Thanks,

[ToniKautto]

Generally it can be a good idea to structure the loads as data layers. Practically this means that you have one QVW per data source, which then extracts the data from each source and stores the result into QVD files. A rule of thumb can be that one extract QVW should only utilize one connection.

In the next layer you load the different extract QVDs and transform them into one common structure. The transformed data can then also be stored to a second layer of QVD files.

In a final layer you then load the transformed QVDs and build your presentation layer.

This ETL (Extact Transform Load) structure allows you to minimize data transfer from sources, and enables building different transformed structures from the same source data without having to reaccess the source. This will be especially efficient when your deployments grow.

[maxgro]

the syntax for query sql databases depends on the dbms: SQL language is a standard (many standard SQL-86, SQL-92, ......) but every dbms has its own features

If you want more help, you can post your script, post the error, let we know which databases are you querying.

For now we only know you want to do an union of 2 Master tables from 2 different databases.

Above all the answers I see above can be ok or wrong.

ODBC CONNECT TO MTR (XUserId is yyyyy, XPassword is yyyyy);

NewTableName:

SQL SELECT

     'SourceTable 1' as Source,

     Field1,

     Field2,

     '

     '

FROM "Master";

ODBC CONNECT TO BTR (XUserId is xxxxxxxx, XPassword is xxxxx);

CONCATENATE (NewTableName)

SQL SELECT

     'SourceTable 2' as Source,

     Field1,

     Field2,

     '

     '

FROM "Master";