0 ×

String to Duration

StreamableKNIME Date and Time Handling version 4.3.0.v202012011138 by KNIME AG, Zurich, Switzerland

Converts string cells to duration cells. The string representation of these durations needs to be in either the ISO-8601 representation (see date-based duration format or time-based duration format for details, e.g. 'P2Y3M1D'), the short letter representation (e.g. '2y 3M 1d'; Date-based duration: y: years, M: months, d: days; Time-based duration: H: hours, m: minutes, s: seconds) or the long word representation (e.g. '2 years 3 months 1 day').

Options

Column Selection

Column Selector
Only the included columns will be converted.

Replace/Append Selection

Append selected columns
The selected columns will be appended to the input table. The suffix of the appended columns can be provided in the text field to the right.
Replace selected columns
The selected columns will be replaced by the new columns.

Type Selection

Automatically detect type
It will be automatically detected, whether a date-based or a time-based duration shall be parsed. The type will be determined based on the first cell in each column which can be successfully parsed.
Create time-based duration
All included columns will be converted to time-based duration columns (their data type is "Period").
Create date-based duration
All included columns will be converted to date-based duration columns (their data type is "Duration").
Fail on error
If checked, the node will abort the execution and fail on errors. If unchecked, missing values will be generated instead.

Input Ports

Icon
Input table.

Output Ports

Icon
Output table with duration columns.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

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

KNIME 4.3

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.