Icon

02. Data Manipulation_​ex

There has been no title set for this workflow's metadata.

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

URL: Advaced ETL Functionalities and Machine Learning based Pre-Processing https://youtu.be/IEAsUTN8q68
URL: Joining Data Tables https://youtu.be/6BigLM6vbhs
URL: Joining Data Tables - Inner Join https://youtu.be/9uV99ByH-TA
URL: Concatenate https://youtu.be/VzH2lHbDAg0
URL: Concatenate Node https://youtu.be/ku6SyEZ1Pv8
URL: Data Manipulation: Numbers, Strings, and Rules https://youtu.be/mJrBXmLQ4ko
URL: Slides (KNIME Analytics Platform Course) https://www.knime.com/form/material-download-registration

Import Data Activity: Data Manipulation & AggregationImport data from: - Sentiment Analysis.table - Sentiment Rating.csv - Product Data2.xls (hint: Drag and drop files from the KNIME Explorer panel)Optional: Read the web_activity table from the database WebActivity.sqlite Activity I - Part 3 - Join all data into one table using a series of joiner nodes(use "Customer Key" as the joining column) Activity I - Part 1 - Concatenate web activity data from the old andnew systems Activity I - Part 2 - Replace the written sentiment values with thenumeric sentiment scores Activity II - Filter out duplicate rows - Make sure that all product names in the product data spreadsheet are writtenin lower case letters (String Manipulation or Column Expressions) - Remove the column Sentiment Rating (Table Manipulator) - Calculate the mean age of the customers per product (GroupBy node) Import Data Activity: Data Manipulation & AggregationImport data from: - Sentiment Analysis.table - Sentiment Rating.csv - Product Data2.xls (hint: Drag and drop files from the KNIME Explorer panel)Optional: Read the web_activity table from the database WebActivity.sqlite Activity I - Part 3 - Join all data into one table using a series of joiner nodes(use "Customer Key" as the joining column) Activity I - Part 1 - Concatenate web activity data from the old andnew systems Activity I - Part 2 - Replace the written sentiment values with thenumeric sentiment scores Activity II - Filter out duplicate rows - Make sure that all product names in the product data spreadsheet are writtenin lower case letters (String Manipulation or Column Expressions) - Remove the column Sentiment Rating (Table Manipulator) - Calculate the mean age of the customers per product (GroupBy node)

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: 2023-09-02
Last update: 2024-11-18
Created with KNIME version: v5.1.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!