Icon

02. Data Manipulation - solution

Data Manipulation - Solution
Activity I - Concatenate web activity data from old and new systems. Activity: Data Manipulation & Aggregation - Make sure that all product names in the product data spreadsheet are written inlower case letters - Replace the written sentiment values with the numeric sentiment scores Activity I - Concatenate web activity data from the old and new systems Activity II - Join all data into one table using a series of joiner nodes (use "Customer Key" as the joiningcolumn) - Filter out duplicate rows Numeric sentimentscoresCombine oldand new systemAdd Demographics dataAdd sentiment analysisadd product dataexclude Sentiment Ratingand Web ActivityDemographics and History from SAS fileSentiment Evaluation from KNIMESentiment Rating +Sentiment DescriptionOld Web DataChange product valuesto lower caseWebActivity.sqliteWebActivityRemove duplicaterowsProducts<-> CustomerKey Cell Replacer Concatenate Joiner Joiner Joiner Column Filter File Reader Table Reader File Reader File Reader String Manipulation SQLite Connector DB Reader DB Table Selector DuplicateRow Filter Excel Reader (XLS) Activity I - Concatenate web activity data from old and new systems. Activity: Data Manipulation & Aggregation - Make sure that all product names in the product data spreadsheet are written inlower case letters - Replace the written sentiment values with the numeric sentiment scores Activity I - Concatenate web activity data from the old and new systems Activity II - Join all data into one table using a series of joiner nodes (use "Customer Key" as the joiningcolumn) - Filter out duplicate rows Numeric sentimentscoresCombine oldand new systemAdd Demographics dataAdd sentiment analysisadd product dataexclude Sentiment Ratingand Web ActivityDemographics and History from SAS fileSentiment Evaluation from KNIMESentiment Rating +Sentiment DescriptionOld Web DataChange product valuesto lower caseWebActivity.sqliteWebActivityRemove duplicaterowsProducts<-> CustomerKeyCell Replacer Concatenate Joiner Joiner Joiner Column Filter File Reader Table Reader File Reader File Reader String Manipulation SQLite Connector DB Reader DB Table Selector DuplicateRow Filter Excel Reader (XLS)

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: 2020-04-09
Last update: 2024-11-18
Created with KNIME version: v4.1.1
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!