topic Re: Joining/Keeping after outer join in QlikView

Joining/Keeping after outer join

Anonymous — Wed, 31 Jul 2013 07:00:26 GMT

Hi All,

I have a table say "Test" in which I am outer joining few tables. After that there is another table in which I am using fields from table Test, something like this:

Test:

Load

...,

...

Resident A;

Join (Test)

Load

...,

...

Resident B;

and so on. After this I am creating another table using fields from Test

Test1:

Load

Sum(...),

...,

Resident Test

group by ...;

Now the problem is that after Test table has been loaded, It takes a lot of time to load table Test1.

When I checked in log file i found that after Test is loaded, there is a statment Joining/Keeping and then Test1 starts loading. However, I do not want this table Test1 to be joined to anything. I tried using Noconcatenate also, but i am not able to make it work.

Anybody has any ideas on this?

Re: Joining/Keeping after outer join

Wed, 31 Jul 2013 07:17:47 GMT

Test:

Load

...,

...

Resident A;

Join (Test)

Load

...,

...

Resident B;

Drop table A;

Drop table B;

Test1:

Noconcatenate

Load

Sum(...),

...

Resident Test

group by ...;

Drop table Test;

//After Joining Test table it will take little bit more time to create Test1 table...

regards -bika

Re: Joining/Keeping after outer join

Wed, 31 Jul 2013 07:19:54 GMT

try to use keep

Re: Joining/Keeping after outer join

Anonymous — Wed, 31 Jul 2013 07:22:05 GMT

I am already using Noconcatenate, is it necessary to drop the tables A & B?

Re: Joining/Keeping after outer join

juleshartley — Tue, 14 Mar 2017 11:19:00 GMT

I've got exactly this issue - for some reason the log says that a keep/join is happening, when I have not asked one to! No idea why...

Re: Joining/Keeping after outer join

aapurva09 — Wed, 22 Mar 2017 09:32:19 GMT

Another option is to create a new column in the Test1 table as below:

Test1:

Load

Sum(...),

'' AS JUNK

...

Resident Test

group by ...;

Drop table Test;

this will prevent the table to auto concatenate with the tables above. Then you can drop this JUNK column.

Let me know if it works.

Re: Joining/Keeping after outer join

swuehl — Wed, 22 Mar 2017 09:35:36 GMT

Not sure I understand. You are joining two or more tables before loading Test1, so the log entry is ok for me.

Does it not show up when you remove the script code for Test1?