Filtering a table effectively by a certain date

KNIME Analytics Platform
#1

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?

#2

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

3 Likes
#3

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.