How to use Max()

[brendafos]

My data returns a row for every page in a stack of scaning.  I want to filter out and keep only the row which is the MAX of the page number values

Pat ID | Doc ID | Doc Type | Page Number

001 | 3003 | Lab Results | 01

001 | 3003 | Lab Results | 02

001 | 3003 | Lab Results | 03

001 | 3003 | Lab Results | 04

So from the example data above I would want to only return the Page Number 04 row.

I think I would use the filter tool, but how would I write the custom Max()?

[tom_montpool]

This might also be a good use case for the Unique tool -- sort your data on page number, then drop a unique tool after it, choosing unique Pat ID, Doc ID and Doc Type.

[RyanDonovanNG]

I agree.  Seems if you append to a table that had a million rows, performance would be affected.  All want to do is just compare to ONE value