DB duplicate row filter


I was wondering is there DB Node similar to “duplicate row filter”?

I am trying to filter whole DB table and get ride of duplicate rows and keep only those where date is newest.

I want to choose let’s say Product column where Knime should find duplicate and select only row where max delivery date.

@89trunks if your database supports Window functions like RANK you can use that:


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.