Second version of same qvd

[#1]

T_BDE_DAILY:
LOAD
[Loan Number],
[First Principal Balance] as UPB,
[Hi Type],
[Lo Type],
[Next Payment Due Date] as  [Payment Due Date]

FROM $(qvd_layer_2_path)T_BDE_DAILY.qvd(qvd)
where [Loss Mit Status Code] = 'A' and [Servicing Sold ID] <> 'X22' and [Referral Code] <> 'ssw' ;

The above is in a tab and represents the main filter for a report

I know need to pull from another version of the exact database qvd.  The only difference is this version only uses the first part of the where statement

T_BDE_DAILY_temp:
LOAD
[Loan Number],
[First Principal Balance] as UPB,
[Hi Type],
[Lo Type],
[Next Payment Due Date] as  [Payment Due Date]

FROM $(qvd_layer_2_path)T_BDE_DAILY.qvd(qvd)
where [Loss Mit Status Code] = 'A' ;

Is it better to create a file and use a right join in the same tab or would it be better to create a new tab

[MK_QSL]

FullQVD:

Load * From QVDName;

NoConcatenate

T1:
Load * Resident FullQVD where condition....

T2:
Load * Resident FullQVD where condition....

Drop Table FullQVD;

[its_anandrjs]

Hi,

As i understand if you are load second table with filter part A only for records with this filter but you already filter that rows in the first load. But in second load difference is that you load only only [Loss Mit Status Code] = 'A'.

Then try one of this ways

1.  First Way

T_BDE_DAILY:

Load * From T_BDE_DAILY.qvd Where Conditions..........;

Right Join

T_BDE_DAILY_temp:

Load * From T_BDE_DAILY.qvd Where Conditions..........;

2. Second Way is

T_BDE_DAILY:

Load * From T_BDE_DAILY.qvd Where Conditions..........;

Concatenate

T_BDE_DAILY_temp:

Load * From T_BDE_DAILY.qvd Where Conditions..........;

Regards

Anand