The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at
http://knime.com.
Date Field Extractor
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.
Dialog Options
- Column containing dates
-
Select the input column containing the dates.
- Year
- Check if the year should be extracted and appended
as an integer column. The name for this column can be specified.
- Quarter
- Check if the quarter as a number in [1,4] should
be extracted and appended as an integer column.
The name for this column can be specified.
- Month
- Check if the month should be extracted and appended
as an extra column. Select whether the (English) name of the month
should be appended to the output table (Text) or the number of the
month (Number) in [1, 12]. The name for this column can be specified.
- Day
- Check if the day of month should be extracted and
appended as an integer column.
The name for this column can be specified.
- Day of Week
- Check if the day of week should be
extracted and appended as an extra column. Select whether the (English)
name of the day (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday)
should be appended to the output table (Text) or the number of the
day in the week (Number) in [1, 7] starting with Sunday.
The name of this column can be specified.
- Day of Year
- Check if the day of year should be
extracted and appended as an integer column.
The name of this column can be specified.
Ports
Input Ports
0 |
Table containing date/time cells. |
Output Ports
0 |
Input table with extracted date fields appended |
This node is contained in KNIME Time Series Nodes
provided by KNIME GmbH, Konstanz, Germany.