Filtering a table effectively by a certain date

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?


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:



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