Most recent record by date

[rams007]

I Have data like below

changed_by	updated_at
1	2021-04-23T13:24:49.362Z
1	2021-04-23T13:26:13.601Z
2	2021-02-19T14:48:38.857Z
2	2021-03-10T09:28:41.247Z
2	2021-03-10T09:48:19.995Z
3	2022-05-30T06:49:19.206Z
3	2022-09-20T13:19:30.601Z

I need the resulting table to look like this

changed_by	updated_at
1	2021-04-23T13:26:13.601Z
2	2021-03-10T09:48:19.995Z
3	2022-09-20T13:19:30.601Z

[a_mullick]

Hi,

You can use a MAX() function in a chart to pick out the latest timestap:

[Kushal_Chawda]

@rams007  try below

Data:
Load changed_by,
     timestamp(Timestamp#(updated_at,'YYYY-MM-DDThh:mm:ss.fffZ')) as updated_at  
FROM Source;

Inner Join(Data)
Load changed_by,
     timestamp(max(updated_at)) as updated_at
Resident Data
Group by changed_by;