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.
Options
Column Selection
Field Selection
Popular Predecessors
- Date&Time Difference7 %
- Date&Time to legacy Date&Time3 %
- Rule-based Row Filter3 %
- Date&Time Part Extractor3 %
Row Filter (deprecated)2 %- Create Date&Time Range2 %
- String Manipulation2 %
Excel Reader (XLS)2 %- Extract Time Window (legacy)2 %
- Extract Duration Fields2 %
Column Appender2 %- Date&Time to String2 %
- Number to String2 %
- String Manipulation (Variable)2 %
- One Row to Many2 %
- Date Extractor2 %
- Mask Date/Time (legacy)2 %
- Column Resorter2 %
- Rule Engine2 %
- Modify Date2 %
- Column Aggregator2 %
- Duration to String2 %
- Moving Aggregator2 %
- CSV Reader2 %
- Excel Reader2 %
- GroupBy1 %
- Math Formula1 %
- Legacy Date&Time to Date&Time1 %
- String to Date&Time1 %
- String to Duration1 %
- UNIX Timestamp to Date&Time1 %
- Date&Time Shift1 %
List Files1 %- Column Filter1 %
- Timer Info1 %
- Modify Time1 %
- String to Date/Time (legacy)1 %
- DB Writer1 %
- Column Expressions (legacy)1 %
- Joiner1 %
- Table Editor (JavaScript)1 %
- Python Script (legacy)1 %
Database Reader1 %Column Rename1 %- Cell Splitter1 %
CSV Reader< 1 %- Concatenate< 1 %
Joiner< 1 %- Row Sampling< 1 %
- Date&Time-based Row Filter< 1 %
- Table Creator< 1 %
- Pivot< 1 %
Extract Date&Time Fields< 1 %- Chunk Loop Start< 1 %
- Double to Integer< 1 %
- Nominal Value Row Splitter< 1 %
- Table Transposer< 1 %
- Group Loop Start< 1 %
- Column Merger< 1 %
- Missing Value Column Filter< 1 %
Number To String< 1 %- Missing Value< 1 %
- Sorter< 1 %
- Statistics< 1 %
- Duration to Number< 1 %
- Benchmark End< 1 %
- Lag Column< 1 %
Linear Correlation< 1 %- Kaplan-Meier Estimator< 1 %
- Extract Table Spec< 1 %
- DB Reader< 1 %
- Random Label Assigner< 1 %
Excel Reader (XLS)< 1 %- Modify Time Zone< 1 %
- Window Loop Start< 1 %
- Time Generator (legacy)< 1 %
- Variable to Table Row< 1 %
- File Reader< 1 %
- Constant Value Column< 1 %
- Duplicate Row Filter< 1 %
- Table Manipulator< 1 %
- Number Rounder< 1 %
- DB Query Reader< 1 %
- Extract Outline Labeling< 1 %
Views
- This node has no views
Workflows
01_Guided_Analytics_for_ML_AutomationKNIME Hub- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- Show all 11 workflows
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.