Hub
NodeNode / Manipulator

Extract Duration Fields

Other Data Types Time Series Transform Streamable
Drag & drop
Like
Copy short link

Extracts the selected fields from a duration column and appends the values as integer or long columns. Valid fields are hours, minutes, seconds, milli- micro- and nanoseconds for a time-based duration and years, months and days for a date-based duration.

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Output table
    Output table containing the extracted fields as appended columns.

Extension

The Extract Duration Fields node is part of this extension:

Related workflows & nodes

  1. Date Add
    eamendola > Public > Date Add
    eamendola
  2. examples with timestamps and durations and file names
    Timestamp Date Time
    +2
    use the current timestamp to construct a filename
    mlauber71 > Public > kn_example_timestamp_as_filename
    mlauber71
  3. Idle Time Calculator
    elsamuel > Public > Idle Time Calculator
    elsamuel
  4. Duration to time format
    Duration Time Timestamp
    Duration to time format
    mlauber71 > Forum > 2021 > kn_forum_38395_duration_to_time_format
    mlauber71
  5. Guided Automation
    AutoML Guided analytics Automated machine learning
    +11
    Download the entire workflow group from the Example Server. This Guided Analytics applica…
    knime > Examples > 50_Applications > 36_Guided_Analytics_for_ML_Automation > 01_Guided_Analytics_for_ML_Automation > 01_Guided_Analytics_for_ML_Automation
    knime
  6. Guided Automation
    AutoML Guided analytics Automated machine learning
    +11
    Download the entire workflow group from the Example Server. This Guided Analytics applica…
    mortenrai > Public > 01_Guided_Analytics_for_ML_Automation
    mortenrai
  7. Guided Automation
    AutoML Guided analytics Automated machine learning
    +11
    Download the entire workflow group from the Example Server. This Guided Analytics applica…
    bgriff > Public > 01_Guided_Analytics_for_ML_Automation
    bgriff
  8. Guided Automation
    AutoML Guided analytics Automated machine learning
    +11
    Download the entire workflow group from the Example Server. This Guided Analytics applica…
    prashantks > Public > 01_Guided_Analytics_for_ML_Automation
    prashantks
  9. Guided Automation
    AutoML Guided analytics Automated machine learning
    +11
    Download the entire workflow group from the Example Server. This Guided Analytics applica…
    ealbuger > Public > 01_Guided_Analytics_for_ML_Automation
    ealbuger