Is there a node that can filter a datetime field from a db?

[mlauber71]

You could take a look at this example and adapt that:

Efficient way of doing a JOIN ... WHERE ...

Well, not a particularly sophisticated idea but you could try and use a local H2 database to join two datasets by time ranges. Depending on the power of your machine and other factors that might work. I tried it with files of different sizes and at least it gives you a result. [image] Until there is a solution in KNIME you could explore further the possibilities of using SQL to make the join more efficient. I took from this older entry: There might be some special limitations when workin…

Typically it would depend on the syntax of the (SQL) database.you are using.