Filtering a table effectively by a certain date

[knimerin]

Hi, I have a really huge table (>700.000 entries). The table contains data for 4 years. I need to filter out the first half year effectively. Saying this it’s not always exactly half a year but I get the exact date from which the filtering shall begin from another table, i. e. I can’t use “Date&Time-based Row Filter”.

My first thought was to join that exact filter date with the big table and using rule engine. Maybe you have a more efficient solution for me?

[armingrudd]

Hi,

You can use Date&Time-based Row Filter node.
Use flow variables to pass the date from the other table to the node.
Here is a short tutorial about flow variables:
https://blog.statinfer.com/knime-spirits-at-your-service/

Best,
Armin