Timestamp Alignment

This component checks whether the selected timestamp column is uniformly sampled in the selected time scale. Missing values will be inserted at skipped sampling times.

Required extensions:
KNIME Quick Forms
(https://hub.knime.com/knime/extensions/org.knime.features.js.quickforms/latest)

Topics: IoT, Internet of Things, Signal Processing

Options

Replace timestamp column
If checked, then the timestamp column will be replaced with the new timestamp column with uniform sampling. Otherwise, the new timestamp column will be appended to the input table.
Timestamp Column
The timestamp column to check for uniform sampling.
Period
Select the timestamp interval.%%00010%%00010The following periods are supported:%%00010Year%%00010Month%%00010Week%%00010Day%%00010Hour%%00010Minute%%00010Second%%00010

Input Ports

Icon
Data table containing at least one column of datetime type (Local Date, Local Time, Local Date Time, Zoned Date Time).

Output Ports

Icon
Data table containing the input data table with extra rows if skipped sampling times are found. If replace timestamp column boolean is checked, then the input timestamp column will be replaced with the new timestamp column with uniform sampling, Otherwise the new timestamp column will be appended to the input table.

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2019-07-18
Last update: 2024-04-23
Created with KNIME version: v4.1.3

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

Try NodePit Runner!