Icon

BKeegan_​Data Blending Exercise 2

Data Manipulation

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 I - Concatenate web activity data from the old and new systems Activity: Data Manipulation & Aggregation - Replace the written sentiment values with the numeric sentiment scores Activity II - Join all data into one table using a series of joiner nodes (use "Customer Key" as the joiningcolumn) Demographics and History from SAS fileSentiment Evaluation from KNIMESentiment Rating +Sentiment DescriptionOld Web DataWebActivity.sqliteWebActivityProducts<-> CustomerKeyNode 250Node 251Node 252Node 253Node 254Node 255 File Reader Table Reader File Reader File Reader SQLite Connector DB Reader DB Table Selector Excel Reader (XLS) Concatenate Cell Replacer Joiner Joiner Joiner Table Writer Activity I - Concatenate web activity data from the old and new systems Activity: Data Manipulation & Aggregation - Replace the written sentiment values with the numeric sentiment scores Activity II - Join all data into one table using a series of joiner nodes (use "Customer Key" as the joiningcolumn) Demographics and History from SAS fileSentiment Evaluation from KNIMESentiment Rating +Sentiment DescriptionOld Web DataWebActivity.sqliteWebActivityProducts<-> CustomerKeyNode 250Node 251Node 252Node 253Node 254Node 255 File Reader Table Reader File Reader File Reader SQLite Connector DB Reader DB Table Selector Excel Reader (XLS) Concatenate Cell Replacer Joiner Joiner Joiner Table Writer

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-07-29
Last update: 2024-11-09
Created with KNIME version: v4.1.2
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!