Left join

[#1]

Hi Everyone,

I am having trouble using left join, my laptop freezes whenever I load script containing left join

I am trying to load two tables which have a common field Project Number, I want to do left join because I want to see all the project numbers from table1 including the project numbers that exist in table1 but not table2 by using left join.

Apparently I am doing something wrong or it just the qlikview that is not supporting left join , my laptop completely freezes it took me 5 reboots to realize that the script is what causing it.

Could someone please help on an alternative solution like an If or where condition instead of left join?

Apprecite your help on this

Thanks,

Anusha

[#2]

Hi Anusha,

Did you try use Concatenate?

Data:

LOAD A,

          B,

          C,

          [Project Number]

From Table1;

Concatenate

LOAD D,

          E,

          F,

          [Project Number]

From Table2

Where ;

The result is all table 1 and table 2 but you can try build another tabla like this:

Select *

Resident Data

Where D =  null();

That's no the solution but I believe It can help.

Please load an example or your script!

Regards,

Diego.

[#3]

Thanks for the inputs

[#4]

Left keep seems to be right, and it is not freezing the system

Thank You

[#5]

That's the best way to keep tables intact and simple.

[#6]

Now that the keep function works I am trying to seggregate the project numbers based on their existence,

I am only looking at the project numbers from table2 so I am using right keep and

right keep

LOAD

if([Project Definition]= exists([Project Number],[Project Definition]),[Project Definition],'Null') as [Project Number],

week,

     cat,

so on fields

from table2.

but I am only seeing null label  in my chart even the drill is gone.

Could you please help me on how can get all project numbers from table2 and see the drill for those which are present in table1 and those which are not present in table1 as null

[#7]

can u post sample qvw with excel data

[#8]

I am not allowed to share apparently!!!

Anyways could you help check conditions for two fields that would solve some of my problems

load count()

resident table1

where KAM='';

Project Definition belongs to table1 and KAM field belongs to table2

I know sql I can use table1.commonfiled=table2.commonfield

When I run this script obviously KAM is not in table1 and it isgiving me an error KAM field not found, but I need to check Proj DEf from table1 has null value or not when KAM is null , how do I link field from two tables?

[#9]

Instead of counting at Script level I counted in the expressions at chart level that worked

Thanks