Tab1
$(qvd_name)
: Load
[ID Number] ,
[Department Name]
from
QVD\Layer 2\T_Department.qvd](
qvd)
Tab 2
left join
NoConcatenate
[table 2]
LOAD
[ID Number] ,
[Hiire Date]
FROM
(qvd)
Where [Hire Date] >0;
[Employee Rec]
Load
[ID Number],
max(Hire Date]) as [Date Hire]
Resident
[table 3]:]:
load
[ID Number] ,
max(s483_Dt) as [483 Dt],
max(s324_Dt) as [324 Dt],
max(s367_Dt) as [367 Dt]
Resident [tabe 2]
Group by [ID Number];
drop Table [table 2];
STORE
$(qvd_name) into $(qvd_layer_3_path) $(qvd_name).qvd (qvd);
In this example table 1 is the source table. Table 2 has a common field called ID
