Extracts the selected date fields from a date/time column and appends the values as integer columns. Available fields are year, quarter, month, day, day of week. If these values are not set in the date/time cell a missing value is added in the result table.
Options
Popular Successors
- GroupBy9 %
- Rule-based Row Filter4 %
- Java Snippet (simple)3 %
Row Filter (deprecated)3 %- Pivot3 %
- Date Field Extractor (legacy)3 %
- Rule Engine2 %
Excel Sheet Appender (XLS)2 %- Excel Writer2 %
- Partitioning2 %
- Math Formula2 %
- Send to Tableau Server2 %
- R Snippet1 %
- Cross Joiner1 %
Column Appender1 %- Date&Time Part Extractor< 1 %
- Joiner< 1 %
- Cell Splitter< 1 %
- Column Filter< 1 %
- Missing Value< 1 %
XLS Writer< 1 %- 2D/3D Scatterplot< 1 %
- Catch Errors (Data Ports)< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %- Number Rounder< 1 %
- String Manipulation< 1 %
- Legacy Date&Time to Date&Time< 1 %
Database Writer< 1 %- Reference Row Filter< 1 %
- RowID< 1 %
- Line Plot (JavaScript)< 1 %
- Date/Time Shift (legacy)< 1 %
- Column Auto Type Cast< 1 %
- String to Number< 1 %
- Linear Correlation< 1 %
- Numeric Row Splitter< 1 %
- Column Splitter< 1 %
- Line Chart (JFreeChart)< 1 %
- Group Loop Start< 1 %
- Auto-Binner< 1 %
- Lag Column< 1 %
- Reference Row Splitter< 1 %
- Rank< 1 %
Column Rename< 1 %- String Manipulation (Multi Column)< 1 %
Rank Correlation< 1 %- Time Series Generator< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Date&Time Difference< 1 %
- String to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Table Row to Variable< 1 %
Table Row To Variable Loop Start< 1 %CSV Writer< 1 %- Concatenate< 1 %
- Case Converter< 1 %
- Column Combiner< 1 %
- Number to String< 1 %
- Column Rename (Regex)< 1 %
- Column Resorter< 1 %
- Constant Value Column< 1 %
- Domain Calculator< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %Joiner< 1 %- Table Manipulator< 1 %
Number To String (PMML)< 1 %- Sorter< 1 %
- Rule-based Row Splitter< 1 %
- Numeric Outliers< 1 %
- Box Plot (legacy)< 1 %
- Color Manager< 1 %
- Column Expressions< 1 %
Excel Writer (XLS)< 1 %- Table View (JavaScript)< 1 %
- Date&Time to String< 1 %
- Date&Time to legacy Date&Time< 1 %
Extract Date&Time Fields< 1 %- Modify Date< 1 %
- Modify Time Zone< 1 %
- Time Field Extractor (legacy)< 1 %
- Moving Average< 1 %
- String to Date/Time (legacy)< 1 %
- CSV Writer< 1 %
- Random Forest Predictor (Regression)< 1 %
Linear Correlation< 1 %- Normalizer< 1 %
- Crosstab< 1 %
- Similarity Search< 1 %
Column Filter QuickForm (legacy)< 1 %Table Column to Variable< 1 %- Java Snippet< 1 %
Loop End< 1 %Counting Loop Start< 1 %- Cell Splitter By Position< 1 %
- Column Comparator< 1 %
- Column Aggregator< 1 %
- Duplicate Row Filter< 1 %
- Value Counter< 1 %
- Statistics< 1 %
- Parallel Coordinates (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- DL4J Feedforward Learner (Regression) (legacy)< 1 %
- Math Formula (Multi Column)< 1 %
Excel Writer (XLS)< 1 %- Value Selection (legacy)< 1 %
- Moving Aggregator< 1 %
- ARIMA Visualization< 1 %
- Create Collection Column< 1 %
Variable to Table Column< 1 %- Variable to Table Column< 1 %
- Create File Name (legacy)< 1 %
- Inject Variables (Data)< 1 %
Database Connector< 1 %Table Writer< 1 %- Chunk Loop Start< 1 %
- PNN Learner (DDA)< 1 %
- Decision Tree Learner< 1 %
- Regression Predictor< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Auto-Binner (Apply)< 1 %
- Binner (Dictionary)< 1 %
Cell Replacer< 1 %- Category to Number< 1 %
- One to Many< 1 %
- Edit Numeric Domain< 1 %
- Row Filter (Labs)< 1 %
Missing Value< 1 %Normalizer< 1 %- Row Sampling< 1 %
String Replace (Dictionary)< 1 %- Rule-based Row Splitter (Dictionary)< 1 %
CASE Switch Data (End)< 1 %- Conditional Box Plot (legacy)< 1 %
- Histogram (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Counter Generation< 1 %
- Random Number Assigner< 1 %
DL4J Feedforward Learner (legacy)< 1 %- Bar Chart (JFreeChart)< 1 %
- Java Snippet Row Filter< 1 %
- Java Snippet Row Splitter< 1 %
- String Matcher< 1 %
- Column Filter (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time Shift< 1 %
- Mask Date/Time (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- XGBoost Predictor (Regression)< 1 %
- Uniquify IDs< 1 %
- Number Formatter< 1 %
- Group Mutual Information< 1 %
- ARIMA Predictor< 1 %
- Extract Variables (Data)< 1 %
Table Row to Variable< 1 %Database Update< 1 %Database Looping< 1 %Parameterized Database Query< 1 %Database Table Creator< 1 %Table Reader< 1 %Variable Condition Loop End< 1 %- X-Aggregator< 1 %
- X-Partitioner< 1 %
Naive Bayes Predictor< 1 %- Fuzzy Rule Learner< 1 %
- Fuzzy c-Means< 1 %
- Hierarchical Clustering< 1 %
k-Means< 1 %- k-Means< 1 %
- Linear Regression Learner< 1 %
Scorer< 1 %Tree Ensemble Learner (Regression)< 1 %Gradient Boosted Trees Learner< 1 %Gradient Boosted Trees Learner (Regression)< 1 %- Random Forest Learner (Regression)< 1 %
Random Forest Predictor< 1 %- Simple Regression Tree Learner< 1 %
- Simple Regression Tree Predictor< 1 %
Concatenate (Optional in)< 1 %- Numeric Binner< 1 %
Cell Splitter< 1 %- Number to Category (Apply)< 1 %
Number To String< 1 %String To Number< 1 %- Column Name Extractor< 1 %
- Column Merger< 1 %
- Column to Grid< 1 %
- Correlation Filter< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
Double To Int< 1 %- Double to Integer< 1 %
Column Filter< 1 %- Reference Column Filter< 1 %
- Filter Apply< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Numeric Binner (PMML)< 1 %
- Missing Value (Apply)< 1 %
- Number to String (PMML)< 1 %
String To Number (PMML)< 1 %- String Replacer< 1 %
- Table Difference Finder< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Data Explorer< 1 %
- One-way ANOVA< 1 %
- Friedman Test< 1 %
- Independent groups t-test< 1 %
- End IF< 1 %
- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- Cache< 1 %
- Extract Table Spec< 1 %
- Interactive Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Molecule Type Cast< 1 %
- DB Writer< 1 %
- DB Table Creator< 1 %
- Random Matcher< 1 %
- Numeric Distances< 1 %
- Bar Chart (JavaScript)< 1 %
- Box Plot (JavaScript)< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- Table to H2O< 1 %
- Math Formula (Variable)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- JPython Function (Legacy)< 1 %
XLS Sheet Appender< 1 %Send to Power BI< 1 %R Snippet< 1 %Open TIBCO Spotfire< 1 %- Google Sheets Updater< 1 %
- Value Filter (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Hierarchy Extractor< 1 %
- Feature List Filter< 1 %
- Object Inserter< 1 %
- Multiobjective Score Computation< 1 %
Python Script (1⇒1)< 1 %Python Script (1⇒2)< 1 %Python Script (2⇒1)< 1 %- R Learner< 1 %
- R View (Table)< 1 %
- Table Difference Checker< 1 %
- String to Duration< 1 %
- Modify Time< 1 %
- Time Difference (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Time to String (legacy)< 1 %
- Date Extractor< 1 %
- URL Resolver< 1 %
- HTTP Retriever< 1 %
Views
- This node has no views
Workflows
(Optional)_Linear_RegressionKNIME Hub- 01 Document ViewerKNIME Hub
- 01_Simple_Statistics_on_KNIME_ForumKNIME Hub
- 02 Reading Text DataKNIME Hub
- 02_Customers_Trx_Money_vs_LoyaltyKNIME Hub
- Show all 36 workflows
Links
- No links available
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.