I have a table with dates, correctly type cast to dates. I’d like to filter rows based a column such that I see dates that are outside the range, e.g. outside 01-11-2022 and 31/01/2023. I can’t work out how to do that using the tools available.
Tried using the date&time based row filter, but it only allows me to see the items within the range, not the negative.
with the rule-based row filter I can’t work out a function to cast a string or variable to a date, like a
date() or similar.
I’m new to KNIME so this might be straightforward, but can’t see an obvious way to do this.
Help would be super appreciated.
Welcome to the forum, @bmansoor.
A splitter node will allow you to keep all records.
If I start with a column of dates ranging from 2021-06-02 (this is yyyy-mm-dd) to 2023-06-02:
I can use a Rule-Based Row Splitter node to grab, for example, all dates except those in January 2023:
Heere are the outputs:
The Reference Row Filter is always a nice trick to use to find remaining rows as well.
Thanks, this is exactly what I needed and works perfectly.
If you have any insight into why the date needs to be in quotes, would love to understand that too. Without context, I would have assumed that treated the contents within the quotes as a string rather than a date.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.