Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

qlikview0585
New Contributor

Joining/Keeping after outer join

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?

6 Replies
Not applicable

Re: Joining/Keeping after outer join

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

Not applicable

Re: Joining/Keeping after outer join

try to use keep

qlikview0585
New Contributor

Re: Joining/Keeping after outer join

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

juleshartley
Valued Contributor

Re: Joining/Keeping after outer join

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

aapurva09
Contributor

Re: Joining/Keeping after outer join

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.

MVP
MVP

Re: Joining/Keeping after outer join

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?

Community Browser