Joining Multiple Data Sources

[andre_avenant]

Hi All

How do you concatenate two different data sources from two different SQl DB's.

The data is the same...if you just do a normal load you get a lot of Synthetic keys.

Thanks in advance

[max_potass · Accepted solution]

First: Are the Fieldnames definitly the same?

Second: did you use concetanate between the loads?

If yes try:

Load both tables seperatly and store them. Drop them. Load them from qvd file.

Table1:
Load
     your first load srcipt
from ..;

Table2:
Load
     your second load script
from...;

Store Table1 into Table1.qvd;
Store Table2 into Table2.qvd;

drop tables Table1, Table2;

FullTable:
Load * From Table1.qvd;

concetanate

Load * From Table2.qvd;

[sasiparupudi1 · Accepted solution]

Connect statement first db

T1:

SQL Select

F1,

F2,

F3,

F4

From your table;

Connect statement second db;

Concatenate(T1)

SQL Select

F1,

F2,

F3,

F4

From your table;

[andre_avenant]

Hello

Thanks. It now gives me the errors:

I can individually see the QVD , but cannot see the data even if I just load it

[max_potass]

What does your data look like if you just load one of the two? I guess you have the problem already there, so in the sql import.