Hub
NodeNode / Manipulator

Date Field Extractor (legacy)

Other Data Types Time Series Time Series (legacy)
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    Input column
    Table containing date/time cells.
Output ports
  1. Type: Table
    Extracted date fields
    Input table with extracted date fields appended

Extension

The Date Field Extractor (legacy) node is part of this extension:

Related workflows & nodes

  1. superstore project
    santhosh1011 > Public > superstore project
    santhosh1011
  2. superstore project1
    santhosh1011 > Public > superstore project1
    santhosh1011
  3. EDA
    sp07 > Public > EDA
    sp07
  4. Data Chef ETL Battles. Customer Transactions: Money vs. Loyalty.
    ETL KNIME Data manipulation
    +5
    In this workflow we convert raw customer transactions, i.e. contract registrations, into …
    knime > Examples > 02_ETL_Data_Manipulation > 06_Date_and_Time_Manipulation > 02_Customers_Trx_Money_vs_Loyalty
    knime
  5. Solana_DeGods_project3_team4
    karthik_r_patil > Public > ETL_Solanablockchain_data
    karthik_r_patil
  6. Usage Measures vs. auto-correlation on Energy Consumption Time Series
    ETL KNIME Data manipulation
    +6
    The theme ingredient in this workflow is Energy Consumption Time Series. What kind of var…
    knime > Examples > 02_ETL_Data_Manipulation > 06_Date_and_Time_Manipulation > 03_ETL_Energy_autocorr_stats
    knime
  7. Usage Measures vs. auto-correlation on Energy Consumption Time Series
    ETL KNIME Data manipulation
    +6
    The theme ingredient in this workflow is Energy Consumption Time Series. What kind of var…
    fede_peconi > Public > 03_ETL_Energy_autocorr_stats
    fede_peconi
  8. 02 Reading Text Data
    Text mining Text processing Pdf
    +4
    L4-TP SELF-PACED COURSE exercise. Encapsulate text and its metainformation from strings t…
    bojesphob > Public > L4-TP Introduction to Text Processing > Lab > 02 Reading Text Data
    bojesphob
  9. 01 Document Viewer
    Text mining Text processing Document viewer
    +2
    L4-TP SELF-PACED COURSE exercise. Explore documents with the Document Viewer node.
    bojesphob > Public > L4-TP Introduction to Text Processing > Lab > 01 Document Viewer
    bojesphob
  10. 03 Tagging
    Text mining Text processing Tag
    +4
    L4-TP SELF-PACED COURSE exercise. Apply parts-of-speech, named entity, and wildcard taggi…
    bojesphob > Public > L4-TP Introduction to Text Processing > Lab > 03 Tagging
    bojesphob