Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

Help me to get the latest records in script level.

Hi All,

Please help me to get the latest record by writing the code in script level.

Sample data:   

CUSTIDDATEDESC
101
10123-Jul-2017Reminder to log in
10123-Aug-2017xyz
102
10223-Jul-2017Reminder to log in
10223-Sep-2017abc

Expected output:   

CUSTIDDATEDESC
10123-Aug-2017xyz
10223-Sep-2017abc

Please advice.

Thanks,

Durga

2 Replies
marcelviegas
Creator II
Creator II

table_Sanple:

load

CUSTID,DATE,DESC,CUSTID&'|'&DATE as key

from table;

inner join

load CUSTID&'|'&max(DATE) as key

resident table_Sanple

group by CUSTID:

mayankraoka
Specialist
Specialist

Hi,

Check attached QVW for solution

Regards,

Mayank