Icon

02. Data Blending

Data Reading Activity: Data Manipulation & Aggregation Activity I- Concatenate web activity data from old and new systems. Get data for sentiment analysis Activity II- Join all data together using a series of Joiner nodes by the "Customer Key" field.- Clean up and document your workflow using annotations, node labels and metanodes.- Create a wrapped metanode and save it as template. Exclude Sentiment Ratingand Web ActivityWeb activity(old system)Demographics and History from SAS fileSentiment Analysis Web Activity (Old)First Web Activityfrom New Web SystemWeb Activity (New)Read Product DataNode 242 Column Filter Column Rename File Reader Table Reader File Reader Database Reader(legacy) SQLite Connector(legacy) Excel Reader (XLS) Concatenate join on customer Data Reading Activity: Data Manipulation & Aggregation Activity I- Concatenate web activity data from old and new systems. Get data for sentiment analysis Activity II- Join all data together using a series of Joiner nodes by the "Customer Key" field.- Clean up and document your workflow using annotations, node labels and metanodes.- Create a wrapped metanode and save it as template. Exclude Sentiment Ratingand Web ActivityWeb activity(old system)Demographics and History from SAS fileSentiment Analysis Web Activity (Old)First Web Activityfrom New Web SystemWeb Activity (New)Read Product DataNode 242 Column Filter Column Rename File Reader Table Reader File Reader Database Reader(legacy) SQLite Connector(legacy) Excel Reader (XLS) Concatenate join on customer

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: 2019-10-03
Last update: 2024-11-23
Created with KNIME version: v4.0.1

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

Try NodePit Runner!