NodeDate&Time-based Row Filter

Manipulator

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.

Input Ports

  1. Port Type: Data
    Input table.

Output Ports

  1. Port Type: Data
    Filtered output table.

  1. Empty the Server Trash Bin

    REST API KNIMEServer
    You can use this workflow to connect to a KNIME Server, list the trash contents and select a cutoff date to retain workf…
    knime > Examples > 09_Enterprise > 01_Server > 03_Using_KNIMEServer_REST_API > 03_Empty_Trash_on_KNIME_Server

  2. Inventory Optimization Use Case: Guided Analytics Workflow

    Retail
    WebPortal based business application, allowing review of inventory KPIs, consumption forecast, setting of service level …
    knime > Examples > 50_Applications > 41_Inventory_Optimization > 02_Guided_Analytics

  3. Example: Time Series

    This workflow demonstrates different time series functionality. As the usage of various time series nodes for analyzing …
    aajaradata > 01_Example_of_Time_Series_Functionality

  4. Date and Time Analysis - Solution

    Date&Time time series moving average moving aggregation granularity education
    Solution to the exercise 8 for KNIME User Training - Constructing a timestamp from String values - Converting String to …
    knime > Education > 01 KNIME User Training > solutions > 08. Date and Time Analysis - solution

  5. KNIME Server Log Parsing

    REST API KNIMEServer Logs Logfiles Analysis
    This workflow parses logfiles created during the operation of KNIME Server. The workflow was developed using KNIME Serve…
    knime > Examples > 09_Enterprise > 01_Server > 03_Using_KNIMEServer_REST_API > 07_Log_Parser_and_Usage_Reporting_on_KNIME_Server

  6. Time filtering on the webportal

    We here demonstrate how a date/time column can be filtered to contain only the last k month or week or days. On the webp…
    knime > Examples > 09_Enterprise > 02_WebPortal > 05_Select_most_recent_date_and_time_cells

  7. Anomaly Detection. Time Series AR Deployment

    anomaly detection time series analysis auto-regressive models time alignment IoT Internet of Things
    This workflow applies a previously trained auto-regressive model to predict signal values. The model was trained for nor…
    knime > Examples > 50_Applications > 17_AnomalyDetection > 03b_Time_Series_AR_Testing

  8. Filter on First Business Day of Month

    This workflow filters rows with a due date less than or equal to the first business day of the following month. First bu…
    ipazin > 2019_08_21_First_Business_Day_Filter

  9. Example: Time Series

    This workflow demonstrates different time series functionality. As the usage of various time series nodes for analyzing …
    knime > Examples > 04_Analytics > 07_Time_Series > 01_Example_of_Time_Series_Functionality

  10. Anomaly Detection. Time Series AR Training

    anomaly detection time series analysis auto-regressive models time alignment IoT Internet of Things
    This workflow trains an auto-regressive model to predict signal values. Only time series values from normal functioning …
    knime > Examples > 50_Applications > 17_AnomalyDetection > 02_Time_Series_AR_Training