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.
- Type: Data Table containing date/time cells.
- Type: Data Input table with extracted date fields appended
Data Ch(i)ef ETL Battles. Usage Measures vs. auto-correlation on Energy Consumption Time SeriesETL KNIME data manipulation time series energy consumption auto-correlation correlation time analysis time series analysisTheme ingredient is Energy Consumption Time Series. Which kind of variables can we extract from energy consumption data?…knime > Examples > 02_ETL_Data_Manipulation > 06_Date_and_Time_Manipulation > 03_ETL_Energy_autocorr_stats
Data Chef ETL Battles. Customer Transactions: Money vs. Loyalty.ETL KNIME data manipulation loyalty customer intelligence raw transactions contract moneyIn this workflow we convert raw customer transactions, that is contract registrations, into money measures on one side a…knime > Examples > 02_ETL_Data_Manipulation > 06_Date_and_Time_Manipulation > 02_Customers_Trx_Money_vs_Loyalty
Public Google Sheet meets Excel Sheet.Google Google Sheet Excel Excel Sheet YTD REST REST service ExcelAccounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we wan…knime > Examples > 01_Data_Access > 05_REST_Web_Services > 04_Public_Google_Sheet-meets-Excel
KNIME Forum Analysis. Simple Statistics of Posts and AnswersNLP text processing natural language processingThis workflow generates measures about the forum, like number of users, number of posts, number and percent of answered …knime > Examples > 50_Applications > 07_Forum_Analysis_of_the_KNIME_Forum > 01_Simple_Statistics_on_KNIME_Forum
Private Google Sheet meets Excel Sheet.Google Google Sheet Excel Excel Sheet YTD REST REST service ExcelAccounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we wan…knime > Examples > 01_Data_Access > 05_REST_Web_Services > 05_Private_Google_Sheet-meets-Excel
KNIME Forum Analysis. Topic Classification in PostsNLP text processing natural language processingThis workflow performs a supervised topic classification on the forum posts. The training set consists of the descriptio…knime > Examples > 50_Applications > 07_Forum_Analysis_of_the_KNIME_Forum > 02_Text_Classification_from_Forum_Posts
Grab_Data_from_Inside_AirBNBknime > Examples > 50_Applications > 26_Model_Process_Management > Process > AirBNB_Cities > _meta_workflows > Grab_Data_from_Inside_AirBNB