Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Date&Time-based Row Filter
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Filter_by_days_in_the_past
    maarit > Public > Demos > Filter_by_days_in_the_past
    maarit
  2. Go to item
    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
    ipazin
  3. Go to item
    Date&Time filtering example
    elsamuel > Public > Date&Time filtering example
    elsamuel
  4. Go to item
    jKi-5
    Justknimeit-5
    There has been no description set for this workflow's metadata.
    cf_123 > Public > jKi-5
    cf_123
  5. Go to item
    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
    data_coach
  6. Go to item
    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
    data_coach
  7. Go to item
    Challenge 5 - Date to Fiscal Year
    Justknimeit Justknimeit-5
    Solution to Just KNIME It! challenge #5.
    alinebessa > Public > Challenge 5 - Date to Fiscal Year
    alinebessa
  8. Go to item
    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
    knime
  9. Go to item
    KNIME_create_table
    elsamuel > Public > KNIME_create_table
    elsamuel
  10. Go to item
    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
    knime
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits