topic Preceding load with left join filter by status? in QlikView

Preceding load with left join filter by status?

Fri, 11 Mar 2016 14:21:05 GMT

I have these tables, that i want to filter by status, but Preceding Load does not work because of the left join I think. I have tried resident load but could not get that to work either. I want the table to only load Person_ID with the Status='Married' any tips?

Person:

LOAD

"Person_ID",

Name,

Age,

WorkID;

FROM "Test.st002".dbo.person

Left Join (Person)

LOAD

"Person_ID",

Status,

Gender,

FROM

(biff, embedded labels, table is Sheet1$);

Thx

Re: Preceding load with left join filter by status?

sunny_talwar — Fri, 11 Mar 2016 14:23:28 GMT

May be this:

Person:

LOAD

"Person_ID",

Name,

Age,

WorkID;

FROM "Test.st002".dbo.person

Right Join (Person)

LOAD

"PersonID",

Status,

Gender,

FROM

(biff, embedded labels, table is Sheet1$)

Where Status = 'Married';

Re: Preceding load with left join filter by status?

Fri, 11 Mar 2016 14:28:36 GMT

It worked, thanks Sunny, can you explain why it worked with right join and not left join?

Re: Preceding load with left join filter by status?

sunny_talwar — Fri, 11 Mar 2016 14:32:07 GMT

Since the goal is to remove the data from your left table based on whatever is available in your right table (think of it as the right table being the boss here) you would do right join. If in case you want to remove data from the table that is joined (right table) then you would do a left join (left table is the boss)

Re: Preceding load with left join filter by status?

Fri, 11 Mar 2016 14:35:04 GMT

Like a charm, thx again.