Date&Time Aligner

Select a timestamp column and a time granularity. The node will verify that a record exists in your table for each value at that granularity, for example if you select hours it will check for 01:00, 02:00, 03:00… if a timestamp is not found it will be inserted and missing values generated for the remaining columns. The final output is sorted in ascending order of newly generated timestsamp. Use this in combination with the missing value node to correct missing time series data. This node preserves duplicated values and possibly lead to cluttered output. Therefore, in case of duplicated timestamps, we encourage using Date&Time Aggregator node before using this node.

Options

Timestamp Alignment Parameters

Settings for configuring Timestamp Alignment node.

Timestamp Column

Timestamp column containing missing timestamps.

Replace Timestamp Column

Check this box in order to preserve the original timestamp column in the input table.

Period

Select time granularity to fill the timestampes. Each timestamp filled will be in the 1 frequency interval for the selected granularity.

Available options:

  • Year: Impute missing years in the range
  • Month: Impute missing months in the given range
  • Week: Imupte missing weeks in the given range
  • Day: Impute missing dates in the given range
  • Hour: Impute missing hours in the given range
  • Minute: Impute missing minutes in the given date range
  • Seconds: Impute missing seconds in the given range

Input Ports

Icon

Table containing the timestamp column to fill in for the missing timestamps based on the time granularity selected.

Output Ports

Icon

Table output with the column with missing timestamps in the given range.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

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.

Installation

To use this node in KNIME, install the extension Time Series Extension from the below update site following our NodePit Product and Node Installation Guide:

v5.2

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

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 1.0.0.202403181002
On NodePit since: 2023-12-06
Last update: 2024-04-30
KNIME versions: Since v5.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!