Icon

02. Data Manipulation - Exercise

Data Manipulation - Exercise

Exercise 2 for KNIME User Training
- Concatenate data from two different sources
- Bring values from a reference table to the actual table using the Cell Replacer node
- Modify String values
- Join data from multiple tables
- Remove duplicates in the data

Activity: Data Manipulation & Aggregation Activity I - Part 3 - Join all data into one table using a series of joiner nodes(use "Customer Key" as the joining column) Activity I - Part 1 - Concatenate web activity data from the old andnew systems Activity I - Part 2 - Replace the written sentiment values with thenumeric sentiment scores Activity II - Filter out duplicate rows - Make sure that all product names in the product data spreadsheet are writtenin lower case letters (String Manipulation or Column Expressions) - Remove the column Sentiment Rating (Table Manipulator) - Calculate the mean age of the customers per product (GroupBy node) WebActivity.sqliteWebActivityOld Web DataSentiment Rating+Sentiment DescriptionDemographicsand Historyfrom SAS fileProducts<-> CustomerKeySentiment Evaluation from KNIME SQLite Connector DB Reader DB Table Selector CSV Reader CSV Reader CSV Reader Excel Reader Table Reader Activity: Data Manipulation & Aggregation Activity I - Part 3 - Join all data into one table using a series of joiner nodes(use "Customer Key" as the joining column) Activity I - Part 1 - Concatenate web activity data from the old andnew systems Activity I - Part 2 - Replace the written sentiment values with thenumeric sentiment scores Activity II - Filter out duplicate rows - Make sure that all product names in the product data spreadsheet are writtenin lower case letters (String Manipulation or Column Expressions) - Remove the column Sentiment Rating (Table Manipulator) - Calculate the mean age of the customers per product (GroupBy node) WebActivity.sqliteWebActivityOld Web DataSentiment Rating+Sentiment DescriptionDemographicsand Historyfrom SAS fileProducts<-> CustomerKeySentiment Evaluation from KNIME SQLite Connector DB Reader DB Table Selector CSV Reader CSV Reader CSV Reader Excel Reader Table Reader

Nodes

Extensions

Links