0 ×

Time Difference (legacy)

KNIME Time Series Nodes version 4.2.0.v202003271454 by KNIME AG, Zurich, Switzerland

Appends the difference between two dates with the selected aggregation level (year, quarter, month, week, day, hour, minute) and a selected precision for rounding. For the second date/time there are four possibilities. The node can be configured to use the time at execution, the entries of a second column, a fixed date/time, or the time contained in the previous row.

Options

Use execution time: Calculates the difference "current time" - "first date column"
Use second column: Calculates the difference "second date column" - "first date column"
Use fixed date: Calculates the difference "fixed date" - "first selected column"
Use previous row: Calculates in row n the difference "first date column in row n" - "first date column in row n - 1". The first cell will be missing.
Select first date column: Select the column containing the start date ("first date column")
Select second date column: Select a second column containing the end date ("second date column"; only for option "Use second column" available)
Select granularity of time difference: The granularity of the difference (in years, quarters, months, weeks, days, hours, minutes)
Rounding mode: How many fraction digits
Appended column name: Name of the newly appended column containing the time difference
Fixed time: Select a fixed time as the end date. ("fixed dates"; only for option "Use fixed date" available)

Input Ports

: In data with at least one date columns

Output Ports

: Out data with the time difference appended

Best Friends (Incoming)

String to Date/Time (legacy) (12 %) Streamable
GroupBy (8 %)
Joiner (7 %)
Date&Time to legacy Date&Time (6 %) Streamable
String to Date&Time (5 %) Streamable
Show all 156 recommendations

Best Friends (Outgoing)

Row Filter (12 %) Streamable
Math Formula (10 %) Streamable
Rule Engine (9 %) Streamable
GroupBy (7 %)
Rule-based Row Filter (7 %) Streamable
Show all 196 recommendations

Workflows

01_Simple_Statistics_on_KNIME_Forum (KNIME Hub)
02_Customers_Trx_Money_vs_Loyalty (KNIME Hub)
03_Parsing_the_KNIME_Forum (KNIME Hub)
03_Transform_andTimeDiff (KNIME Hub)
04_Parsing_the_KNIME_Forum (KNIME Hub)
Show all 6 workflows

Installation

To use this node in KNIME, install KNIME Timeseries nodes from the following update site:

KNIME 4.2

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

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. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.