Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
T_BDE_DAILY:
LOAD
[LOAN NUMBER],
[LOAN SETUP DATE],
FROM $(qvd_layer_2_path)T_BDE_DAILY.qvd(qvd)
where [Loss Mit Status Code] = 'A' and [Servicing Sold ID] <> 'NSM120110' and [Referral Code] <> 'CARC' ;
FINAL_TABLE:
LOAD DISTINCT
[LOAN NUMBER],
[LOAN SETUP DATE]
Resident T_BDE_DAILY;
drop table T_BDE_DAILY;
I NEED TO DO A NOCONCATENATE FROM THE T_BDE_DAILY WITH THE FOLLOWING WHERE CLAUSE
T_BDE_DAILY_TM;
LOAD
[LOAN NUMBER],
[LOAN SETUP DATE],
FROM $(qvd_layer_2_path)T_BDE_DAILY.qvd(qvd)
where [Loss Mit Status Code] = 'A' ;
SINCE I NEED T_BDE_DAILY IN THE FINAL TABLE LOGIC, I AM NOT SURE HOW TO INTEGRATE THE TWO TABLES AS WELL AS WHICH TABLE TO DROP IN THE FINAL TAB.
Hi,
NoConcatenate -- use this
T_BDE_DAILY_TM;
Please check with this..
Sub2u
Hi,
Synthetic table & Synthetic keys will be created in table viewer.
So try to avoid that will change the column names or autonumber with the concatenate two fields...
Sub2u