About EasyMorph Tutorials & Examples Web-help

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


#3

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


#4

Thanks