topic Re: Need help with Joining in QlikView

Need help with Joining

Fri, 01 Mar 2013 16:20:09 GMT

I just recently started on this project and ran into this issue when I need to bring in data from two different sources and combine them with the original table. Now what my issue is how can I join Table_2 and Table_3 with Table_1.

Table_1:

LOAD

Field1,

Field2,

Field3

FROM

D:\USERNAME\file1.qvd (qvd)

;

Table_2:

LOAD

Field3,

Field4

FROM

D:\USERNAME\file2.qvd (qvd)

WHERE

EXISTS(Field3)

;

Table_3:

LOAD

Field2,

Field4

FROM

D:\USERNAME\file3.qvd (qvd)

WHERE

EXISTS(Field2)

;

End Result Needed

Table_1:

Field1,

Field2,

Field3,

Field4

Re: Need help with Joining

Sat, 02 Mar 2013 01:50:51 GMT

You will get a circular reference if you load it this way, because QV will auto-assocate all 3 tables.

If you want to Join, I think what you are after this is:

Table1:
load 
Field1, Field2, Field3
From ...
join (Table1) load
Field3, Field4
From ...
join (Table1) load 
Field2, Field4
From ...

Re: Need help with Joining

Sat, 02 Mar 2013 02:58:21 GMT

try use "concatenate"

Table_1:

LOAD

Field1,

Field2,

Field3

FROM

D:\USERNAME\file1.qvd (qvd)

concatenate

LOAD

Field3,

Field4

FROM

D:\USERNAME\file2.qvd (qvd)

concatenate

LOAD

Field2,

Field4

FROM

D:\USERNAME\file3.qvd (qvd)

Re: Need help with Joining

Sat, 02 Mar 2013 03:17:38 GMT

Concatenate will work, but it's a different result than Joining.

Concatenate will simply append new records to the result set, using Null() for fields not available that are already in the Table.

Join (which can be Left, Right, or Inner, or Outer) will link records based on common field(s), then append columns. See QV help for details, but this is quite similar to a RDMS concept of joins, except that it's going to add the columns to the base table rather than just form a relationship.

Re: Need help with Joining

Sat, 02 Mar 2013 03:26:35 GMT

thanks to the idea