topic Left Join in QlikView

Left Join

Sat, 17 Sep 2011 00:37:08 GMT

Hi,

I am getting the Virtual memory error when trying to do left Join. ' It has only 3 columns in the second table and 4 columns in the first table. I am able to do the join where the table has 25+ colmuns and double the number of rows but it is strange i am getting the error for the number of columns and rows are very less.

Left Join

Sun, 18 Sep 2011 13:15:41 GMT

The behavior you are describing are would make sense if you were using a natural join and had no common field names. Since you are using a left join that shouldn't be the problem causing the virtual memory error. My guess is therefore that you get to many synthetic fields. To resolve this drop tables or fields which are not needed.

Left Join

Mon, 19 Sep 2011 05:12:30 GMT

Hi,

As my knowledge if you r getting virtual memery error the fault is in script .

I am also new to qlickview since i have faced this problem i am telling u this

if it's wrong forgive me

Regards,

Rathish

Left Join

Jason_Michaelides — Mon, 19 Sep 2011 06:49:50 GMT

If you post your script or the application we can take a look for you.

Thanks,

Jason

Left Join

Mon, 19 Sep 2011 13:15:14 GMT

Thanks for the response.

1. No synthetic keys.

2. No issues with the script if i debug and run for 100 rows it is working fine. I am not getting any error.

Left Join

Jason_Michaelides — Mon, 19 Sep 2011 14:17:34 GMT

Please post your app otherwise it's very difficult to help.

Thanks,

Jason

Left Join

Tue, 20 Sep 2011 08:29:36 GMT

hi qlikviewadict,

Can you tell how many records are there in the tables?

As you yourself said while debugging with 100 rows its working fine.. that means the two tables that u r joining have huge number of records, and your virtual ram is low so it is giving this error.

You should know that while joining QlikView keeps all the three tables in the memory, which might be leading to all the RAM being exhausted.

you should probably increase ur RAM in hardware.. i see no other solutions by far.

Rgrds,

Abhinava

Re: Left Join

Jason_Michaelides — Tue, 20 Sep 2011 08:56:48 GMT

Or maybe a left join isn't necessary. Can mapping be used instead? If we can see the app we can advise better.

Left Join

Tue, 20 Sep 2011 09:19:06 GMT

Plz send me the app then we will see the solution for that problem