My SQL equivalent for Duplicate row filter , Concatenate, Pivot nodes

[mlauber71]

@berserkersap

code Duplicate row filter

You could use window functions of your database does support them:

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

For H2 and SQLite the latest KNIME nodes should already support them.