filter for maximum date per a given field

[mlauber71]

@Daniel_Weikert and you can always use a local database and window functions to deal with duplicates in a controlled way (rank, first, last). But for most purposes the new duplicate row filter should do the job

SQLITE and Window Functions

@tobias.koetter thank you for this hint this opens up the whole world of window functions. I downloaded the latest JAR file from the Maven site and told KNIME where to find the driver. [image] [image] @khatuaani now you can benefit from the latest developments with H2 (and SQLite).