Knime 4.4.1 does work with my 4.3.4 workflow

[mlauber71]

@TigerCole SQLite offers a lot of benefits and it does integrate with KNIME. And also with R and Python BTW.

KNIME and SQLite - simple example (4.0 New DB nodes) – mlauber71

The driver used by KNIME is not the latest one but you can change that easily:

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).