Help me to get the latest records in script level.

[durgabhavani]

Hi All,

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

Sample data:   

CUSTID	DATE	DESC
101
101	23-Jul-2017	Reminder to log in
101	23-Aug-2017	xyz
102
102	23-Jul-2017	Reminder to log in
102	23-Sep-2017	abc

Expected output:   

CUSTID	DATE	DESC
101	23-Aug-2017	xyz
102	23-Sep-2017	abc

Please advice.

Thanks,

Durga

[marcelviegas]

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]

Hi,

Check attached QVW for solution

Regards,

Mayank