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.