Load latest Jobcode field value

[Eshwar1]

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

[Eshwar1]

Thank you Hirish, working as expected.😊