Converts string cells to duration cells. The string representation of these durations needs to be in either the ISO-8601 representation (see date-based duration format or time-based duration format for details, e.g. 'P2Y3M1D'), the short letter representation (e.g. '2y 3M 1d'; Date-based duration: y: years, M: months, d: days; Time-based duration: H: hours, m: minutes, s: seconds) or the long word representation (e.g. '2 years 3 months 1 day').
Options
Column Selection
Replace/Append Selection
Type Selection
Popular Successors
- Duration to Number14 %
- Date&Time Shift12 %
- Column Filter7 %
- String to Date&Time4 %
- Extract Duration Fields3 %
- Date&Time Difference3 %
- Column Resorter2 %
- Math Formula2 %
Excel Writer (XLS)2 %- String to Number2 %
- Cross Joiner2 %
- Missing Value2 %
- Rule Engine2 %
- Column Expressions2 %
- Cell Splitter2 %
- Joiner2 %
- Duration to String1 %
Column Rename1 %- String to Duration1 %
- String Manipulation1 %
- Interactive Table (legacy)1 %
Extract Date&Time Fields1 %- Column Appender1 %
- Extract Date&Time Fields1 %
String To Number1 %- Constant Value Column1 %
- GroupBy1 %
- UNIX Timestamp to Date&Time1 %
- Table Row to Variable1 %
- CSV Writer1 %
- Table Column to Variable1 %
Joiner< 1 %- Row Filter< 1 %
- RowID< 1 %
- String to Date/Time (legacy)< 1 %
- Concatenate< 1 %
- Rule-based Row Filter< 1 %
- Column Combiner< 1 %
- Partitioning< 1 %
- IF Switch< 1 %
- Modify Time< 1 %
- Constant Value Column Filter< 1 %
- Row Splitter< 1 %
- Time Field Extractor (legacy)< 1 %
Variable to Table Column< 1 %- One to Many< 1 %
- Scatter Plot (legacy)< 1 %
- Label Transformer< 1 %
- Date&Time-based Row Filter< 1 %
- Date/Time Shift (legacy)< 1 %
- Table Manipulator< 1 %
Table Row to Variable< 1 %- Sorter< 1 %
- Uniquify IDs< 1 %
Loop End< 1 %Generic Loop Start< 1 %- Hierarchical Clustering< 1 %
Cell Replacer< 1 %Number To String< 1 %- Lag Column< 1 %
- Normalizer< 1 %
- Unpivot< 1 %
- Kaplan-Meier Estimator< 1 %
- Statistics< 1 %
- Conditional Box Plot (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Color Manager< 1 %
- Bar Chart (JavaScript)< 1 %
- Bubble Chart (Plotly)< 1 %
Excel Sheet Appender (XLS)< 1 %- Java Snippet (simple)< 1 %
- OpenNLP NE Tagger< 1 %
- Line Plot (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- R Snippet< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Modify Date< 1 %
- Window Loop Start< 1 %
- Mask Date/Time (legacy)< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- String to XML< 1 %
Table Row to Variable< 1 %- Number to String< 1 %
Column Appender< 1 %- Linear Correlation< 1 %
- Double to Integer< 1 %
- Low Variance Filter< 1 %
- String to Number (PMML)< 1 %
- Data Explorer< 1 %
- DB Insert< 1 %
- String to Path< 1 %
- Google Sheets Updater< 1 %
- ROC Curve (JavaScript)< 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 34 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.