Icon

02. Data Manipulation - solution

Data Manipulation - Solution
Activity: Data Manipulation & Aggregation Activity II - Filter out duplicate rows - Make sure that all product names in the product data spreadsheet are written in lower case letters - Remove the column Sentiment Rating (Table Manipulator) - Calculate the mean age of the customers per product (GroupBy node) Activity I - Part 2 - Replace the written sentiment values with the numeric sentimentscores Activity I - Part 1 - Concatenate web activity data from the old and new systems Activity I - Part 3 - Join all data into one table using a series of joiner nodes (use "CustomerKey" as the joining column) Numeric sentimentscoresCombine oldand new systemChange product valuesto lower caseWebActivity.sqliteWebActivityRemove duplicaterowsexclude Sentiment Ratingand Web ActivityOld Web Data Sentiment Rating+Sentiment DescriptionDemographicsand Historyfrom SAS fileProducts<-> CustomerKeySentiment Evaluation from KNIMEAdd sentiment analysisAdd Demographics dataadd product dataMean customer ageper productRemove column SentimentRatingCell Replacer Concatenate String Manipulation SQLite Connector DB Reader DB Table Selector DuplicateRow Filter Column Filter CSV Reader CSV Reader CSV Reader Excel Reader Table Reader Joiner Joiner Joiner GroupBy Table Manipulator Activity: Data Manipulation & Aggregation Activity II - Filter out duplicate rows - Make sure that all product names in the product data spreadsheet are written in lower case letters - Remove the column Sentiment Rating (Table Manipulator) - Calculate the mean age of the customers per product (GroupBy node) Activity I - Part 2 - Replace the written sentiment values with the numeric sentimentscores Activity I - Part 1 - Concatenate web activity data from the old and new systems Activity I - Part 3 - Join all data into one table using a series of joiner nodes (use "CustomerKey" as the joining column) Numeric sentimentscoresCombine oldand new systemChange product valuesto lower caseWebActivity.sqliteWebActivityRemove duplicaterowsexclude Sentiment Ratingand Web ActivityOld Web Data Sentiment Rating+Sentiment DescriptionDemographicsand Historyfrom SAS fileProducts<-> CustomerKeySentiment Evaluation from KNIMEAdd sentiment analysisAdd Demographics dataadd product dataMean customer ageper productRemove column SentimentRatingCell Replacer Concatenate String Manipulation SQLite Connector DB Reader DB Table Selector DuplicateRow Filter Column Filter CSV Reader CSV Reader CSV Reader Excel Reader Table Reader Joiner Joiner Joiner GroupBy Table Manipulator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2022-01-16
Last update: 2024-04-27
Created with KNIME version: v4.4.0
Tags: ETLconcatenatejoinpreprocessingremove duplicatestransformreplaceeducation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!