View the original community article here
Last tested: Mar 19, 2020
If you have line items in a table with duplicate ids, but only wants the most recent items or highest items many times you will try to use a SQL subquery to SELECT MAX(DATE) for the given parameter, but you can create this with table calculations in an explore.
First, sort the explore by the ID. Then, apply a secondary sort to the date column (descending).
Then, we can create a table calculation that checks if the value below the id is a duplicate.
Then, we check the date column for duplicates.