Icon

01_​Simple_​Visualization

Simple Visualization

The Iris dataset contains information about sepal and petal dimensions of three species of Iris flower. For exercise purposes, the dataset has been stored across different sources: a SQLite database, a CSV file, and an Excel file. Data Rows (flower measures) are stored in SQLite and Excel.
In this workflow, first we read the two blocks of rows and concatenate them.
Then, the class number is replaced with the actual class name from the CSV file.
When all information has been blended, some interactive composed visualization is performed in the component named "Visualization": bar chart, histogram, parallel coordinates, box plot, scatter plot, table view.

Example: Simple Visualization

Data reading from different sources: SQLite database, XLS file, CSV.
Data are blended together and visualized via an interactive composite view of simple charts and plots

Importing data into the workflow

Blended data visualization
Ctrl + Double click to inspect the component

Sunburst Chart
Import data to the workflow
DB Reader
Right click -> Interactive View: Visualization
Visualization
Data Explorer
Select table with values
DB Table Selector (deprecated)
Filter out some rows before query
DB Row Filter (deprecated)
Read more values from excel file
Excel Reader
Read class names
CSV Reader
Concatenate in one single dataset
Concatenate
Basic stats
Statistics
Connect to database
SQLite Connector (deprecated)
Remove class index
Column Filter
Add class names
Joiner
Numeric Binner

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: Emilio Silvestri
Created at: 2020-02-05
On NodePit since: 2026-11-05
Last update: 2026-11-10
Created with KNIME version: v5.12.0
Tags: TheGuideBookData AccessCSVExcelSQLiteDatabaseIn-database processingConcatenateData ManipulationJoinData WranglingBar ChartHistogramParallel CoordinatesScatter PlotTable ViewComposite ViewComponentGIDS

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

Try NodePit Runner!