0 ×

Date&Time-based Row Filter

StreamableKNIME Date and Time Handling version 4.0.0.v201905312211 by KNIME AG, Zurich, Switzerland

Extracts all rows where the time value of the selected column lies within a given time window from the input. The time window is specified by a start and either an end date (and time), a duration or a numerical value combined with a granularity.

Options

Column Selection

Date&Time Column
It will be filtered by the date/time of the selected column.

DateTime Selection

Start
The start date (and time) determines the lower bound of the filter. It is only optional, i.e. if no start is defined, there is no lower bound.
Now
Inserts the current time formatted according to the format and locale.
Inclusive
If checked, rows with a value equal to the start (or end) date will be kept in the output. If not checked, only rows with a value strictly later than start (or earlier than end) are kept.
Use Execution Time
If checked, the execution time will be used as filter value, i.e. every execution the current time will be inserted.
End
Optionally an end point or range can be chosen. If unchecked, there is no upper bound.
End: Date&Time
Select to insert an end date (and time) which determines the upper bound of the filter.
End: Duration
Select to insert a format string to use as filter range. All rows which are included in this range, will be in the output. A negative duration defines a range reaching back to the past. The inserted string can be either in
1. the ISO-8601 representation (see date-based duration format or time-based duration format for details), examples below,
2. the short letter representation (e.g. '2y 3M 1d')
Date-based duration: y: years, M: months, d: days
Time-based duration: H: hours, m: minutes, s: seconds
or
3. the long word representation (e.g. '2 years 3 months 1 day').

Examples for ISO-8601 (date-based duration):
  • "P2Y" parses as "+2 years"
  • "P-2Y" parses as "-2 years"
  • "P1Y2M3W4D" parses as "1 year, 2 months, 3 weeks and 4 days"
Examples for ISO-8601 (time-based duration)::
  • "PT15M" parses as "+15 minutes"
  • "-PT15M" parses as "-15 minutes"
  • "PT2H15M3.5S" parses as "2 hours, 15 minutes and 3.5 seconds"
End: Numerical
Select to insert an integer and a granularity to define a filter range. A negative value defines a range reaching back to the past. The granularity can be chosen in years, months, weeks, days, hours, minutes, seconds, milliseconds, nanoseconds.

Input Ports

Input table.

Output Ports

Filtered output table.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install KNIME Date and Time Handling from the following update site:

KNIME 4.0
Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.