Date Field Extractor (legacy)

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.

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