Problems deleting duplicate Records

[mlauber71]

@HolgerKleinert you first will have to define the exact rule that will define a duplicate. And then you can see if the Duplicate Row Filter can help or if you might want to use WINDOW functions with the help of H2 database.

DB SQL - H2 School of duplicates - and how to deal with them – mlauber71

Also you might take a look at this approach by @takbb

Duplicate Filter with more conditions

Hi @rds , your actual requirement appears to be that you are wanting to remove duplicates of Column 1 so that you retain only a single row for each product. Since you have specific criteria by which you want to choose which row to keep, you can just make use of the fact that by default the Duplicate Row Filter will keep the first row it encounters for each duplicate. You can change the criteria used by Duplicate Row Filter (especially by opening the “advanced” setting) but this won’t give you t…