0 ×

Date Field Extractor (legacy)

KNIME Time Series Nodes version 4.0.0.v201905311239 by KNIME AG, Zurich, Switzerland

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

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.
Week of Year
Check if the week of year (the week number) should be extracted and appended as an integer column. The name of this column can be specified.

Input Ports

Table containing date/time cells.

Output Ports

Input table with extracted date fields appended

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install KNIME Core from the following update site:

KNIME 4.0
Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.

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.