Filter to get Last Record

1

How Do you filter on the last record only

ID Util Date
10080 30 01-01-2018
10080 40 01-10-2018
1001 50 01-01-2006
1009 10 10-10-2007
1009 10 10-10-2006
1009 15 10-12-2017

Result:
ID Util Date
10080 40 01-10-2018
1001 50 01-01-2006
1009 15 10-12-2017

I can sort on ID and Date, but do not know how to filter it then to only get the top rows

Thanks

2

I solved this with Aggregate and Max

Thanks

1 Like
3

Another possible solution is to use the “Keep min/max” action.

4

Thanks