NodeDate&Time Difference

Manipulator

Calculates differences between two date&time cells and appends a new column. The output can be either a duration or a selected granularity (years, months, weeks, days, hours, minutes, seconds, millis, nanos). It can be configured to use as second date&time either a second column, the execution date&time, a selected fixed date&time or the date&time contained in the previous row.

Input Ports

  1. Port Type: Data
    Input table.

Output Ports

  1. Port Type: Data
    Output table containing an appended column with the calculated differences.

  1. 24-Month Period Detection

    This workflow using 2 loops and Date&Time integration nodes marks dates that are within 24 months of any other date with…
    ipazin > 2019_07_29_24-Month_Period_Detection

  2. B2B Customer Intelligence Use Case

    Showcasing tools and methods available for the Citizen Data Scientist to improve and predict B2B customer behaviour.
    knime > Examples > 50_Applications > 42_Customer_Intelligence > 01_B2B_Customer_Analytics

  3. Customer prediction with H2O in KNIME

    The purpose of this workflow is to showcase the ease of use of the H2O functionalities from within KNIME. As a real worl…
    shima0011 > 04_Analytics > 15_H2O_Machine_Learning > 07_Customer_prediction_with_H2O

  4. Fault tolerant Workflow orchestration

    This example shows how to orchestrate the fault tolerant execution of multiple local KNIME Workflows. All Workflows in t…
    knime > Examples > 06_Control_Structures > 07_Workflow_Orchestration > 01_Fault_Tolerant_Workflow_Orchestration

  5. Performance and Scalability Testing: Example KNIME with Spark

    This workflows show how to learn a random forest using the KNIME Apache Spark nodes. We here are measuring the speed of …
    knime > Examples > 50_Applications > 53_Performance_and_Scalability > 01_workflows > 03_Spark_for_Performance

  6. Model Deployment Dashboard WebPortal

    Deployment Model Prediction Dashboard WebPortal Interactivity Guided Analytics Flight Delay
    This workflow demontstrates a mode of deploying a model with KNIME. The workflow uploads new unseen data from a local fi…
    knime > Examples > 50_Applications > 27_Deployment_Options > 04_Model_Deployment_dashboard_WebPortal

  7. 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

  8. Inventory Optimization Use Case: Data Preparation, Modeling and Business Logic Workflow

    Retail
    Inventory supply and consumption data is loaded, prepared and later forecasted using ARIMA providing the primary output.…
    knime > Examples > 50_Applications > 41_Inventory_Optimization > 01_Data_Preparation

  9. Clickstream Analysis

    ETL data aggregation data cleaning visualization JavaScript composite view interactive view web page analytics web log file e-commerce analytics clickstream analysis click sequence targeting conversion rate web analytics
    Access, join, and format clickstream data. Identify web page sessions based on user id and time spent on the web page. G…
    knime > Examples > 50_Applications > 52_Clickstream_Analysis > 01_Clickstream_Analysis

  10. Performance and Scalability Testing: Example all native KNIME nodes

    This workflows show how to learn a random forest using native KNIME nodes. We here are measuring the speed of the workfl…
    knime > Examples > 50_Applications > 53_Performance_and_Scalability > 01_workflows > 01_KNIME_for_Performance