Hi All,
i am trying to create a table chart with following fields
Branch_code, job_start_date, Jobcode
iam able to achieve latest job_start_date with using below script
Temp_tab1:
LOAD
Branch_code,
job_start_date,
Jobcode
From Tab.qvd;
NoConcatenate
Final:
Load
Branch_code,
Max(job_start_date) as Job_Start_Date
Resident Temp_tab1
Group by Branch_code;
above script is working fine as iam getting latest Job_Start_Date
i have another field Jobcode need to retrieve latest jobcode
in Final table added the Jobcode field and mention same in Group by clause also
after adding the Jobcode field in Table chart it is not showing latest jobcode
can you suggest how to achieve this
Thank you in advance
Eshwar