Want to remove Left Join

[sona_sa]

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

[CELAMBARASAN]

Hi,

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

Celambarasan

[sona_sa]

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

[CELAMBARASAN]

Hi,

     Could you post the structure of that two tables?

Celambarasan

[rbecher]

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

[sona_sa]

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.

[CELAMBARASAN]

Hi,

Have you tried using Outer join?

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

Celambarasan

[sona_sa]

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

[#9]

Have you tried using a left Keep ??

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

[sona_sa]

No effect