0 ×

String to Duration

StreamableKNIME Date and Time Handling version 3.7.0.v201809261347 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

Input table.

Output Ports

Output table with duration columns.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Update Site

To use this node in KNIME, install KNIME Date and Time Handling from the following update site:

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.