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.
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.
To use this node in KNIME, install the extension KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:
A zipped version of the software site can be downloaded here.
Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.