topic how to join same table from 2 database ? in QlikView

how to join same table from 2 database ?

Wed, 12 May 2010 09:31:33 GMT

i got a problem here, n need some of ur help again..

we have 2 databases online, n have same table name n same ERD

the column have difference name, but the same meaning

n my question is : how to join 2 same table from 2 databases into one table in QlikView?

thx before..

AW:how to join same table from 2 database ?

biester — Wed, 12 May 2010 09:58:50 GMT

Load the 1st table, rename the fields to the name of the fields of the 2nd table, then load the 2nd table; the records of the 2nd table will be concatenated to the ones of the 1st table.

Rgds,
Joachim

how to join same table from 2 database ?

spsrk_84 — Wed, 12 May 2010 10:00:08 GMT

Hi,

Suppose assume u have two databases one is oracle Db and another SqlServer Database

then what u need to do is first get the table 1 details

like this

ODBC Connect To OracleDb( here i am showing just the fornat but u need to Put the exact connection string in this place)

XYZ:

Load

AAA , BBBB , CCC;

SQL

Select * from TABle1;

ODBC Connect To SQLSERVERDb( here i am showing just the fornat but u need to Put the exact connection string in this place)

Join(XYZ)

Load

AAA ,

BBB as BBBB , /////////////////////I have renamed the field since u said if filed names are not same .....

CCC;

SQL

Select * from TABle2;

The above explained is one approach is Abothere approach is Create two different for the two Db files and then join those two Qvd files ,but here u need to drop the earlier db tables otherwise these data will be concatenated to Qvd data and results in duplicates of data....

if u face any problem let me know ........

Regards,

Ajay

how to join same table from 2 database ?

Wed, 12 May 2010 14:25:43 GMT

@biastar @ajay143

thx for ur help..

it works 🙂