{"title":"Duration Part Extractor","nodeType":"Manipulator","id":"*CqubuamAlzYoI76y","factoryName":"org.knime.time.node.extract.durationperiod.ExtractDurationPeriodFieldsNodeFactory2","factoryId":"org.knime.time.node.extract.durationperiod.ExtractDurationPeriodFieldsNodeFactory2","path":["Other Data Types","Time Series","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>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: &#39;All&#39; and &#39;Part&#39;. The &#39;All&#39; variant returns the total of all subsecond parts combined. For example, if the duration is 10.123456789 seconds, selecting &#39;Nanos (All)&#39; would return 123456789 nanoseconds. The &#39;Part&#39; variant extracts only the selected subsecond component. In the same example, selecting &#39;Nanos&#39; 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.\n <br />\n Useful for decomposing durations into components for detailed analysis or visualization.</p>\n        ","shortDescription":"Extracts duration fields from duration cells","keywords":["extract","duration","period","interval","field","part","years","months","days","hours","minutes","seconds","milliseconds","microseconds","nanoseconds"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAbhJREFUOI2NkjFIG1EYx3/vnicJXEwLNgheLr1QokOVBhMnXYouwdWh4FQ3J1NaJ7vUIToYxC5Bu7t0qDq4xLWT0E3aoosRa8CgSVoaDo7X4dL2anNpf/Dg8fj+//d/7/skPoTHDGABX4Fv/AeivQAGEgnLGR4eUoZhvAdk21QEiSWgAei6vprNZjYKhcKdkZFRYZrmYLPZmK/X6w9d1wX4FBhB1/XVlZVXN0op1Wq1VH5xUW1vbanXm5sql8upWCx2EaTVgP5MZmx2efllFMBxHC6rlwCEQiGmp6aQUp53M3iczz8zgwoMw8CyLCvQQNO0e8lksvfngRCCSuWcvf09yodlUqkUUko38P3A5NLSi5rqgm3fPwpUCyF6bNs+bjQaHcWlUqkppXzeLQHAo3Q6fVqtVv8SR6N974BR4AFe2/8M8DuISEQikWI8Hh8Kh8O9tdpV/eyssuO6bhGYB7YBB/gMfMSbiw9+szXgic/UzwTeWKtb66m/yASugWPgDbAOvAUq7eKTW+Jip7+YBL50uEkB3337MtDj/wM/UWAOGAfuAjfAEbALHABhIAtcdUrwLxbwOvKLHy0hwgTU0lgZAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"The input table that contains columns with duration information to extract."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table containing the extracted fields as appended columns."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Duration column","description":"A duration column from which to extract the fields.","optional":false},{"name":"Extracted fields","description":"Define the fields to extract and their column names.\n<ul><li><b>Field</b> : The type of field to extract.\n  <ul><li><b>Years</b> : Extracts the years component of a date-based duration.</li><li><b>Months</b> : Extracts the months component of a date-based duration.</li><li><b>Days</b> : Extracts the days component of a date-based duration.</li><li><b>Hours</b> : Extracts the hours component of a time-based duration.</li><li><b>Minutes</b> : Extracts the minutes component of a time-based duration.</li><li><b>Seconds</b> : Extracts the seconds component of a time-based duration.</li><li><b>Milliseconds</b> : Extracts the milliseconds component of a time-based duration. In other words, a duration of 10.123456789 seconds would have 123 milliseconds.</li><li><b>Microseconds (all subseconds)</b> : 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.</li><li><b>Microseconds</b> : Extracts the microseconds component of a time-based duration. In other words, a duration of 10.123456789 seconds would have 456 microseconds.</li><li><b>Nanoseconds (all subseconds)</b> : 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.</li><li><b>Nanoseconds</b> : Extracts the nanoseconds component of a time-based duration. In other words, a duration of 10.123456789 seconds would have 789 nanoseconds.</li></ul></li><li><b>Column name</b> : The name of the column populated with the values of the selected field.</li></ul>","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171548","bundleName":"KNIME Date and Time Handling","bundleSymbolicName":"org.knime.time","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}