topic Re: Problem with left join in QlikView

Problem with left join

Wed, 24 Apr 2013 08:19:31 GMT

Hello!

I have some problem when i use left join in a script.

I have to big register, tabell1 and tabell2, when i use lefte join it never ending runnin and my memory in my server is very high, Why? When i use smaller register its works!

You can see a example on my scipt:

Tabell1:

Load

from xxx;

Tabell2:

left join load

from zzz;

I hope some one can help me.

Re: Problem with left join

nilesh_gangurde — Wed, 24 Apr 2013 08:27:27 GMT

use the syntax as mentioned below

Tabell1:

Load

from xxx;

left join(Tabell1)

load

from zzz;

Hope this will help.

-Nilesh

Re: Problem with left join

alexandros17 — Wed, 24 Apr 2013 08:43:41 GMT

This happens because the second table contains lots of values c for each a value so the number of rows grow exponentially ...

The good way to manage this problem (when you have low memory) is reduce data before left join, so if you can it would be better to do a select with where on both tables before joining ...

Hope it helps.

Re: Problem with left join

Wed, 24 Apr 2013 08:45:56 GMT

try this

Tabell1:

Load

from xxx;

left join

Tabell2:

load

from zzz;

Re: Problem with left join

andries_bos — Wed, 24 Apr 2013 09:42:28 GMT

I had same issues when there is in a lot of cases no relation between some values in tabel 1 and 2.

If there is no join, it will create information for the possible independant combinations. This will increase mem usage.

Normally I prefer and use, if possible, a 'Keep left' to 'add' new information from the second source.