topic Problems with join data from multiple databases! in QlikView

Problems with join data from multiple databases!

Mon, 26 Jan 2026 18:19:17 GMT

hi folks

here i have problems with joining data from multiple databases, for example i wana join data in 5 different databases by YEAR, MONTH and ORGANIZATION

but the relations doesn't work well. the name of joining fields are same and even i use JOIN() function and i should say that each system individually works well but when i load them together the problem occurs...

plz help

Problems with join data from multiple databases!

yblake — Sun, 17 May 2009 16:18:40 GMT

Why use join ?

if data is the same from 5 sources, use "concatenate" ??

Problems with join data from multiple databases!

Tue, 19 May 2009 04:41:50 GMT

Post your script here, and I will have a look at it for you.

Problems with join data from multiple databases!

Tue, 19 May 2009 11:53:07 GMT

hmmm

"CONCATENATE" I didnt use it before! My script is very huge cuz i use script from 5 qvw files (that each one works properly) so using of it is very complicating

Problems with join data from multiple databases!

Tue, 19 May 2009 12:44:12 GMT

tnx my friends

ok here is my QVW file, i make 3of systems az comment to reduce the file size

thank you for your help...

Problems with join data from multiple databases!

Tue, 19 May 2009 21:38:49 GMT

I believe the basic answer to your question is to use the normal association behavior of QV. The word Join has a very specific meaning in QlikView, which is that you add data from some dataset to a table already loaded in QV. This has the effect of adding columns to a table. That is not what you generally want to do. Association on the other hand, means that you load the second dataset seperately, but QV knows that it is related to the first table based on association. QV assumes an association whenever the column/field in two tables has exactly the same name (case sensitive).

To solve your problem of linking a lot of different data, the solution is to carefully rename columns, so associations are created by QV between the tables based on the columns you want, but not on the ones you don't want. To remove an association, give the field a different name in one of the tables. Another technique is the careful use of the Qualify and Unqualify commands, so that nothing links by default, and you use unqualify to cause linking on just some fields.

I suggest you carefully uncomment load statements one at a time, making sure each one links exactly the way you want it to.

This document has been very helpfull to me, QV 8.5 Reference Manual, here:

http://ftp.qliktech.com/qvwebdownloads/Docs.asp

Look at Book I, Part IV.

Problems with join data from multiple databases!

Wed, 20 May 2009 15:28:50 GMT

Eugene Im very thankful for your suggestion, i'll check out the documents

you know Eugene, this is be so complicated for me but i'll find a way for it.

and when its solved i'll share the solution here

hamid

Problems with join data from multiple databases!

anitamelbye — Tue, 16 Mar 2010 12:57:33 GMT

Hi,

Just wondering if you found a solution. I have the same problem 🙂

Anita

Problems with join data from multiple databases!

anitamelbye — Tue, 16 Mar 2010 13:09:06 GMT

Never mind: CONCATENATE works 🙂