Joining Condition during QVD files.

[#1]

Hi All,

I have a TABLE -1 and TABLE -2

Table-1	Table-2
Name	Date_key
ID	Branch_Key
branch_indicator	Company_key
Company_indicator
Party_Key

I need to create Three QVD's

1. Table2.qvd

2. Table1a.qvd  ( This should have condition Branch_Indicator = 'YES')

3.Table1b.qvd (This Should Have condition Company_indictor = 'YES')

I will be joining TABLE 1A.PARTY_KEY with TABLE2.BRANCH_KEY   and   TABLE 1B.PARTY_KEY with TABLE2.COMPANY_KEY.

This is because, on first condition, I need to get the info of Branches alone. And Second condition, I need to get comapany info.

Can any one pls help me with this ?

Regards,

Praveen

[#2]

PPP:

LOAD

col1

col2;

SQL SELECT *

FROM Table_name;

STORE PPP into C:\Qlikview\PPP.qvd;

LOAD

col1

col2

Resident PPP

where BRANCH_INDICATOR = "Y';

But its throwing an error as Unknown columns. I think its because we are not giving the table name in second session.

[#3]

Thanks Manoj.

Got it

[#4]

Thanks for the Reply Sujeet.