Duration Part Extractor

Extracts selected fields from duration columns and appends them as long columns. For time-based durations, fields include hours, minutes, seconds, milliseconds, microseconds, and nanoseconds. For date-based durations, fields include years, months, and days. For subsecond fields in time-based durations, there are two extraction options: 'All' and 'Part'. The 'All' variant returns the total of all subsecond parts combined. For example, if the duration is 10.123456789 seconds, selecting 'Nanos (All)' would return 123456789 nanoseconds. The 'Part' variant extracts only the selected subsecond component. In the same example, selecting 'Nanos' would return just the nanoseconds part, which is 789. This distinction allows for precise control over how subsecond data is extracted, depending on the level of detail required.
Useful for decomposing durations into components for detailed analysis or visualization.

Options

Duration column
A duration column from which to extract the fields.
Extracted fields
Define the fields to extract and their column names.
  • Field: The type of field to extract.
    • Years: Extracts the years component of a date-based duration.
    • Months: Extracts the months component of a date-based duration.
    • Days: Extracts the days component of a date-based duration.
    • Hours: Extracts the hours component of a time-based duration.
    • Minutes: Extracts the minutes component of a time-based duration.
    • Seconds: Extracts the seconds component of a time-based duration.
    • Milliseconds: Extracts the milliseconds component of a time-based duration. In other words, a duration of 10.123456789 seconds would have 123 milliseconds.
    • Microseconds (all subseconds): Extracts the microseconds of a time-based duration, including all of the subseconds. In other words, a duration of 10.123456789 seconds would have 123456 microseconds.
    • Microseconds: Extracts the microseconds component of a time-based duration. In other words, a duration of 10.123456789 seconds would have 456 microseconds.
    • Nanoseconds (all subseconds): Extracts the Nanoseconds of a time-based duration, including all of the subseconds. In other words, a duration of 10.123456789 seconds would have 123456789 nanoseconds.
    • Nanoseconds: Extracts the nanoseconds component of a time-based duration. In other words, a duration of 10.123456789 seconds would have 789 nanoseconds.
  • Column name: The name of the column populated with the values of the selected field.

Input Ports

Icon
The input table that contains columns with duration information to extract.

Output Ports

Icon
Output table containing the extracted fields as appended columns.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

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.