giad
November 19, 2020, 1:20pm
1
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
Hi @giad
did you checked if “DB Table Selector”-Node in combination with “DB Row Filter” - Node works?
BR
1 Like
You could take a look at this example and adapt that:
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.
system
Closed
May 22, 2021, 12:40am
4
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.