I think it would be great if the duplicate row filter could take in multiple conditions, rather than just one when selecting which row to select from the duplicates. Allow a quick use case to illustrate my point…
If I have the following table that I want to de-dupe based on “Product ID”:
I can use the Duplicate Row Filter and select how I want the selection returned. E.g.:
Which would yield the highlighted row selected:
However, would it be possible to enhance the Duplicate Row Filter to allow another selection if duplicates still exist after defining a row selection.
For example… If I choose my row selection to be Maximum of Effective Date, there are two rows with the same maximum effective date. It would be great to then choose Maximum of Recent Sales from the remaining table. Which would yield this:
And ideally the user could continue to add conditions to select the right row from the duplicates.