topic Re: Issue with Left join in QlikView

Issue with Left join

Anonymous — Thu, 09 May 2013 10:30:37 GMT

Hi,

When I left join Table 2 to Table 1 the Amount becomes null any particular reason.

Table 1 Table 2

ID ID

Branch Amount

Dept

Date

Re: Issue with Left join

er_mohit — Thu, 09 May 2013 10:44:06 GMT

see the attached file

hope it helps

Re: Issue with Left join

calvindk — Thu, 09 May 2013 10:50:43 GMT

Probably because there are no overlapping ID's and you are doing left join

If there are overlapping ID's double check that the formatting is the same.

Re: Issue with Left join

Thu, 09 May 2013 10:51:28 GMT

Dont use a table alias for the 2nd table. Please see attached mate

Cheers,

Byron

Re: Issue with Left join

Anonymous — Thu, 09 May 2013 12:03:45 GMT

Hi,

Table 1 Table 2 Table 3 Table 4

ID ID CID CID

Branch Amount ID Balance

Dept Dept

Date Date

Table 1 (LEFT JOIN ) Table 2 (CONCATENATE) Table 3 LEFT JOIN Table 4

Now the Balance becomes a null field but when I remove the concatenate the Balance has values. And I want just a big FACT Table.

Re: Issue with Left join

Thu, 09 May 2013 12:13:14 GMT

Originally you gave us 2 tables to work with now you have 4. If your requirement has changed please let me know exactly what you working with and what your desired output would be, then I can put something together for you

Re: Issue with Left join

Thu, 09 May 2013 12:18:01 GMT

reason is that no any id are common in both table. so amount display null.

Re: Issue with Left join

Thu, 09 May 2013 12:19:09 GMT

(thumbsup)

Re: Issue with Left join

Anonymous — Thu, 09 May 2013 12:19:18 GMT

Sorry about that initially I thought it was overlapping ID's as Anders Møller stated but i realised it has to do with the model. The above is the requirement I went to merge all into one Fact Table as the desired output.But it seems the Balance field becomes null when i use my approach.Help

Re: Issue with Left join

Anonymous — Thu, 09 May 2013 12:22:15 GMT

But there is CID in Both Table 3 and Table 4...........so when i select CID is should relate to the Balance right?

Re: Issue with Left join

Thu, 09 May 2013 12:26:21 GMT

Well it depends on a few things. If your table 1 contains all possible ID's and then LEFT JOIN every statement

i.e.

table1:

load *

from table1;

left join (table1)

load *

from table2;

left join (table1)

load *

from table3;

left join (table1)

load *

from table4;

if not, then you need to ascertain what is contained in each table. for instance you may need to inner join table1 and table 3 and then left join onto this new table table 2 and then left join table 4

Re: Issue with Left join

Thu, 09 May 2013 12:27:43 GMT

check my last post. if you want and are allowed, just upload the qvw and i will quickly do the joins for you