Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
FullQVD:
Load * From QVDName;
NoConcatenate
T1:
Load * Resident FullQVD where condition....
T2:
Load * Resident FullQVD where condition....
Drop Table FullQVD;
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