topic Re: Joining Multiple Data Sources in QlikView

Joining Multiple Data Sources

andre_avenant — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Joining Multiple Data Sources

max_potass — Thu, 19 Apr 2018 14:58:21 GMT

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;

Re: Joining Multiple Data Sources

sasiparupudi1 — Thu, 19 Apr 2018 17:22:32 GMT

Connect statement first db

T1:

SQL Select

F1,

F2,

F3,

From your table;

Connect statement second db;

Concatenate(T1)

SQL Select

F1,

F2,

F3,

From your table;

Re: Joining Multiple Data Sources

andre_avenant — Fri, 20 Apr 2018 06:19:22 GMT

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

Re: Joining Multiple Data Sources

max_potass — Wed, 25 Apr 2018 11:29:36 GMT

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.