String to Duration

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 "Duration").

Create date-based duration

All included columns will be converted to date-based duration columns (their data type is "Period").

Fail on error

If checked, the node will abort the execution and fail on errors. If unchecked, missing values will be generated instead.

Views

This node has no views

Workflows

• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• Show all 47 workflows

Links

• Convert string to durationby armingrudd on 2019-03-25

  forum.knime.com/p/57290

Developers