topic Want to remove Left Join in QlikView

Want to remove Left Join

sona_sa — Fri, 09 Mar 2012 10:53:28 GMT

Hi QlikView Friends,

I don't want to use Left Join btween two tables in my current Application. Can anyone suggest me what I can use instead of Left Join.

Thanks & Regards,

AKumar

Want to remove Left Join

CELAMBARASAN — Fri, 09 Mar 2012 10:56:19 GMT

Hi,

Could you tell me more why you want to remove Left join?What issue now your facing?

Celambarasan

Want to remove Left Join

sona_sa — Fri, 09 Mar 2012 10:59:52 GMT

Yeah Sure Celambarasan,

Due to Left Join My application size is increasing. Data volume is not more than 50 Lakhs and Application size is 240 MB

Regards,

AKumar

Want to remove Left Join

CELAMBARASAN — Fri, 09 Mar 2012 11:03:07 GMT

Hi,

Could you post the structure of that two tables?

Celambarasan

Want to remove Left Join

rbecher — Fri, 09 Mar 2012 11:09:43 GMT

Just load the two tables without join associated by a key column (could be composite key if more than one field needed) if it's a 1:N relation or associated by a link table if it's N:M relation.

- Ralf

Re: Want to remove Left Join

sona_sa — Fri, 09 Mar 2012 12:19:41 GMT

Hi,

These are the information:

Table Name TESTA - Data Volume - 101905

Table Name TESTB - Data Volume - 260279

Composite Key - Fact_Payment_Link_C02 After Left Join Toata Data volume in this cloumn - 23946

Without Left Join - 260679

Now I want to remove Left Join and Same data volume (23946) I want using another way.

But how, please suggest.

Re: Want to remove Left Join

CELAMBARASAN — Fri, 09 Mar 2012 12:25:51 GMT

Hi,

Have you tried using Outer join?

Instead of join if you have column names same in both table leave as it is.

Celambarasan

Want to remove Left Join

sona_sa — Fri, 09 Mar 2012 12:30:33 GMT

yes but I am not getting proper number of data, when I am using left join, Data is correct.

Want to remove Left Join

Fri, 09 Mar 2012 12:30:44 GMT

Have you tried using a left Keep ??

This should reduce the size of your second table without joining..

Want to remove Left Join

sona_sa — Fri, 09 Mar 2012 12:38:32 GMT

No effect

Want to remove Left Join

Fri, 09 Mar 2012 12:44:44 GMT

How about inner joining the Key from the TestA Table to TestB.??

Surely that is the same as left joining to TableA whilst keeping two tables..

I am confused though.. would 3000 records really make that much difference to your app?

Want to remove Left Join

Fri, 09 Mar 2012 12:45:50 GMT

sorry mis read the record number

doh!

Want to remove Left Join

jagan — Fri, 09 Mar 2012 14:24:22 GMT

Hi,

What is the necessity of joining two tables, just keep the column names unique for the key column, Qlikview automatically joins these tables based on the Key column. If you join manually the data would be redundant.

Hope this helps you.

Regards,

jagan.