Hub
NodeNode / Manipulator

Date&Time-based Row Filter

Other Data Types Time Series Manipulate Streamable
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Output table
    Filtered output table.

Extension

The Date&Time-based Row Filter node is part of this extension:

Related workflows & nodes

  1. Filter_by_days_in_the_past
    maarit > Public > Demos > Filter_by_days_in_the_past
  2. Dynamic Date Filtering
    Dynamic Date Filtering Data Manipulation
    This workflow filters input data until yesterday. Yesterday's date is obtained from today…
    ipazin > Public > 2019_11_27_Dynamic_Date_Filtering
  3. Date&Time filtering example
    elsamuel > Public > Date&Time filtering example
  4. Field Types and Conversions Solution
    data_coach > KNIME Foundations > 4 - Field Types and Conversions > 4 - Field Types and Conversions Practice > Field Types and Conversions Solution
  5. Date&Time-based Row Filter Example
    data_coach > KNIME Foundations > 3 - Manipulating Data > 5 - Date&Time-based Row Filter > Date&Time-based Row Filter Example
  6. Challenge 5 - Date to Fiscal Year
    Justknimeit Justknimeit-5
    Solution to Just KNIME It! challenge #5.
    alinebessa > Public > Challenge 5 - Date to Fiscal Year
  7. jKi-5
    Justknimeit-5
    There has been no description set for this workflow's metadata.
    cf_123 > Public > jKi-5
  8. Filter Timeseries Data Using Flow Variables
    ETL Data manipulation Date
    +1
    This workflow demonstrates using flow variables in the date and time nodes. Here the use …
    knime > Examples > 02_ETL_Data_Manipulation > 06_Date_and_Time_Manipulation > 04_Filter_TimeSeries_Data_Using_FlowVariables
  9. KNIME_create_table
    elsamuel > Public > KNIME_create_table
  10. Challenge 5 - Date to Fiscal Year - Solution
    Justknimeit Justknimeit-5 Flow variables
    +1
    In the accounting firm you work for, you are given contracts which were executed on diffe…
    knime > Just KNIME It! > Challenge 5 - Date to Fiscal Year - Solution