Discussion Board for collaboration on QlikView Scripting.
[ID Number] ,[Department Name]
LOAD [ID Number] ,[Hiire Date]FROM(qvd)
Where [Hire Date] >0;
max(Hire Date]) as [Date Hire]
[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];
$(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
Left Join and NoConcatenate ?
Remove NoConcatenate !!
Also,when you are using Max([Hire Date]), you need to group by ID Number....
Provide your exact error...