Duration to Number

StreamableKNIME Date and Time Handling version 3.7.1.v201901291053 by KNIME AG, Zurich, Switzerland

Converts a duration to the selected field and appends the value as a long or double column. Valid fields are hours, minutes, seconds, nano-, micro- and milliseconds. If the output should be a long value the conversion result will be truncated, e.g. if the duration 1 hour 30 minutes should be converted to hours, the exact output is 1.5 hours whereas the truncated output 1 hour.

Note: Only time-based durations can be converted to numbers, since the conversion of date-based durations is not well defined (e.g. it is not clearly defined how many days a month has).

Options

Column Selection

Column Selector

A time-based duration column can be chosen.

Conversion Settings

Granularity

A granularity (hours, minutes, seconds, nano-, micro- or milliseconds) can be selected to which the duration gets converted.

Exact (double value)

The output will be the exact calculation, e.g. the duration 1 hour 30 minutes 30 seconds will be converted to 1.508 hours or 90.5 minutes or 5430 seconds etc.

Truncated (long value)

The output will be the truncated calculation, e.g. the duration 1 hour 30 minutes 30 seconds will be converted to 1 hour or 90 minutes or 5430 seconds etc.

Input Ports

Input table.

Output Ports

Output table containing the converted field as appended column (either long or double).

Best Friends (Incoming)

• Date&Time Difference (42 %) ManipulatorStreamable
• Joiner (11 %) Manipulator
• String to Date/Time (legacy) (11 %) ManipulatorStreamable
• Database Reader (5 %) Source
• Column Appender (5 %) ManipulatorStreamable
• Cross Joiner (5 %) ManipulatorStreamable
• Row Filter (5 %) ManipulatorStreamable
• GroupBy (5 %) Manipulator
• Math Formula (5 %) ManipulatorStreamable
• Excel Reader (XLS) (5 %) SourceStreamable
• Table Creator (< 1 %) Source
• String To Number (< 1 %) ManipulatorStreamable
• Column Filter (< 1 %) ManipulatorStreamable
• Rule-based Row Splitter (< 1 %) ManipulatorStreamable
• String to Date&Time (< 1 %) ManipulatorStreamable
• String to Duration (< 1 %) ManipulatorStreamable
• Show all 16 recommendations

Best Friends (Outgoing)

• Math Formula (50 %) ManipulatorStreamable
• Column Filter (13 %) ManipulatorStreamable
• GroupBy (13 %) Manipulator
• Color Manager (13 %) Visualizer
• Extract Duration Fields (13 %) ManipulatorStreamable
• Column Rename (< 1 %) ManipulatorStreamable
• UNIX Timestamp to Date&Time (< 1 %) ManipulatorStreamable
• Show all 7 recommendations

Workflows

• 01_Guided_Analytics_for_ML_Automation

Installation

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