NodeNode / Manipulator

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.

Input ports
  1. Input column Type: Data
    Table containing date/time cells.
Output ports
  1. Extracted date fields Type: Data
    Input table with extracted date fields appended
  1. Private Google Sheet meets Excel Sheet.
    Google Google Sheet Excel +5
    Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we wa…
    lcs > Public > 01_Data_Access > 05_REST_Web_Services > 05_Private_Google_Sheet-meets-Excel
  2. Private Google Sheet meets Excel Sheet.
    Google Google Sheet Excel +5
    Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we wa…
    knime > Examples > 01_Data_Access > 05_REST_Web_Services > 05_Private_Google_Sheet-meets-Excel
  3. Public Google Sheet meets Excel Sheet.
    Google Google Sheet Excel +5
    Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we wa…
    knime > Examples > 01_Data_Access > 05_REST_Web_Services > 04_Public_Google_Sheet-meets-Excel
  4. Public Google Sheet meets Excel Sheet.
    Google Google Sheet Excel +5
    Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we wa…
    lcs > Public > 01_Data_Access > 05_REST_Web_Services > 04_Public_Google_Sheet-meets-Excel
  5. TR_Reports_IncidentMetric3
    lp00557408 > Public > TR_Reports_IncidentMetric3
  6. KNIME Forum Success Measures
    NLP text processing natural language processing +2
    This workflow generates simple statistics of posts and answers in the KNIME forum, such as the number of users, number …
    knime > Examples > 50_Applications > 07_Forum_Analysis_of_the_KNIME_Forum > 01_Simple_Statistics_on_KNIME_Forum
  7. Grab_Data_from_Inside_AirBNB
    knime > Examples > 50_Applications > 26_Model_Process_Management > Process > AirBNB_Cities > _meta_workflows > Grab_Data_from_Inside_AirBNB
  8. 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 money measures on the one hand…
    knime > Examples > 02_ETL_Data_Manipulation > 06_Date_and_Time_Manipulation > 02_Customers_Trx_Money_vs_Loyalty
  9. 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 variables can we extract from ene…
    knime > Examples > 02_ETL_Data_Manipulation > 06_Date_and_Time_Manipulation > 03_ETL_Energy_autocorr_stats
  10. Assigning Topics to the KNIME Forum Posts
    NLP text processing natural language processing +2
    This workflow performs a supervised topic classification on the forum posts. The training set consists of the descripti…
    knime > Examples > 50_Applications > 07_Forum_Analysis_of_the_KNIME_Forum > 02_Text_Classification_from_Forum_Posts