Icon

Ch2_​Workflow_​Examples

Reading data from files

Reading data from databases

Filtering


This workflow contains examples of data access from file and from database, data conversion, data transformation, and data visualization.

Aggregations

Data Transformations

Exclude Customerkey 11177
DB Row Filter
Connect to WebActivity.sqlite
SQLite Connector
CustomerKey
Number to String
replace(Gender, "F", "Female")
String Manipulation
CustomerKey
String to Number
remove record 11177
Reference Row Filter
women vs. men married vs. single count
Pivot
records to remove
Table Creator
replace(Gender, "M", "Male")
String Manipulation
women vs. men count and avg(age)
GroupBy
lowercase(Gender)
String Manipulation
* ROWCOUNT
Math Formula (Multi Column)
Concatenate
table web_activity
DB Table Selector
back from avg
Math Formula
import
DB Reader
lowercase(Gender) lowercase(MaritalStatus)
String Manipulation (Multi Column)
Column Filter
Demographics.csv
File Reader
ProductData2.xls
Excel Reader
SentimentAnalysis.table
Table Reader
SentimentRating.csv
File Reader
WebdataOldSystem.csv
File Reader
on SentimentAnalysis
Joiner
on CustomerKey
Joiner
on CustomerKey
Joiner
First(WebActivity)
Column Renamer
on CustomerKey
Joiner
remove record 11177
Row Filter
only men
Row Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Rosaria Silipo
Created at: 2020-07-30
On NodePit since: 2020-12-17
Last update: 2026-11-10
Created with KNIME version: v5.4.2

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

Try NodePit Runner!