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

[giad]

Hi!
I need to filter a range into a datetime field from a db table, but before the db reader node because I have to eliminate all data that not enter into this range…

Which node can I use? I know date&time based row filter but it works after the db reader node. I need one before.

Thanks!
Giada

[morpheus]

Hi @giad

did you checked if “DB Table Selector”-Node in combination with “DB Row Filter” - Node works?

BR

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