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()?
Solved! Go to Solution.
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.
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