Icon

Data Manipulation and Blending

Data Manipulation
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 "CustomerKey" as the joining column) - Filter out duplicate rows Activity: Data Manipulation and Blending - Replace the written sentiment values with the numericsentiment scores. (Hint: Use Cell Replacer Node.) - Make sure that all product names in the product dataspreadsheet are written in lower case letters Sentiment Evaluation from KNIMEWebActivity.sqliteWebActivityOld Web DataSentiment Rating+Sentiment DescriptionDemographicsand Historyfrom SAS fileProducts<-> CustomerKeyNode 254Node 255Node 256Node 257Node 258Node 259Node 260Node 261 Table Reader(deprecated) SQLite Connector DB Reader DB Table Selector CSV Reader CSV Reader CSV Reader Excel Reader Cell Replacer Concatenate String Manipulation Column Filter Joiner Joiner Joiner DuplicateRow Filter 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 "CustomerKey" as the joining column) - Filter out duplicate rows Activity: Data Manipulation and Blending - Replace the written sentiment values with the numericsentiment scores. (Hint: Use Cell Replacer Node.) - Make sure that all product names in the product dataspreadsheet are written in lower case letters Sentiment Evaluation from KNIMEWebActivity.sqliteWebActivityOld Web DataSentiment Rating+Sentiment DescriptionDemographicsand Historyfrom SAS fileProducts<-> CustomerKeyNode 254Node 255Node 256Node 257Node 258Node 259Node 260Node 261 Table Reader(deprecated) SQLite Connector DB Reader DB Table Selector CSV Reader CSV Reader CSV Reader Excel Reader Cell Replacer Concatenate String Manipulation Column Filter Joiner Joiner Joiner DuplicateRow Filter

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-10-26
Last update: 2024-04-28
Created with KNIME version: v4.6.3
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!