Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Problems with join data from multiple databases!

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

1 Solution

Accepted Solutions
Not applicable

Problems with join data from multiple databases!

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.

8 Replies
yblake
Contributor II

Problems with join data from multiple databases!

Why use join ?

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

Not applicable

Problems with join data from multiple databases!

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

Not applicable

Problems with join data from multiple databases!

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

Not applicable

Problems with join data from multiple databases!

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...

Not applicable

Problems with join data from multiple databases!

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.

Not applicable

Problems with join data from multiple databases!

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 Wink

hamid

anitamelbye
New Contributor III

Problems with join data from multiple databases!

Hi,

Just wondering if you found a solution. I have the same problem :-)

Anita

anitamelbye
New Contributor III

Problems with join data from multiple databases!

Never mind: CONCATENATE works :-)

A

Community Browser