Load ID by Max date in Script

[priya945]

Hi All,

Below might be a basic but not able to attain the output. Please help

Test:
LOAD * Inline [

ID, Date
1, 7/28/2020 11:26:51 PM
1, 7/27/2020 10:04:20 AM
1, -

2, 7/29/2020 10:03:21 AM

];

Output

ID	Date
1	7/28/2020 23:26 PM
2	7/29/2020 10:03 AM

Thanks

[brijesh_fofadiy]

Hi Priya,

Please use below expression to get your result :

Aggr(Date(Max(Date)),ID)

[priya945 · Accepted solution]

Solution may be as below

NoConcatenate
Test1:
LOAD ID,
max(Date) as Date

Resident Test
Group By ID;

DROP Table Test;