Icon

flight integration

Creating dimension airline

Creating dimension airport

Creating dimension time

Creating dimension hour

Creating fact table

read flights.csv
CSV Reader
read airlines.csv
CSV Reader
unmatch origin airports
Table View
read airports.csv
CSV Reader
check origin airport join
Joiner
remove rows with unmatched airport
Row Filter
check destination airport join
Joiner
unmatch destination airports
Table View
read airports.csv
CSV Reader
read flights.csv
CSV Reader
keep only flight and airline
Column Filter
flight + airline
Column Combiner
remove duplicates
Duplicate Row Filter
remove latitude/longitude
Column Filter
add airline-flight
Column Combiner
join to get airline names
Joiner
keep only level attributes
Column Filter
drop useless columns
Column Filter
read airline.csv
CSV Reader
create date key
Column Combiner
Duplicate Row Filter
read flights.csv
CSV Reader
arrival time
Column Filter
check nulls
Statistics View
Duplicate Row Filter
remove null values
Row Filter
departure time
Column Filter
adding primary key and foreign keys to fact table
DB SQL Executor
Column Renamer
load airport dimension
DB Writer
union departure and arrival hours
Set Operator
adding hour range
Math Formula
PostgreSQL Connector
adding primary key to hour dimension
DB SQL Executor
Column Renamer
PostgreSQL Connector
load time dimension
DB Writer
PostgreSQL Connector
load raw csv
DB Writer
create and load fact table
DB Writer
adding period of the day
Rule Engine
create and load dimension hour
DB Writer
PostgreSQL Connector
import raw CSV into DB
DB Writer
Column Renamer
create table airline_dim
DB Table Structure Creator
PostgreSQL Connector
distribution of unmatched airports
Pie Chart
Duplicate Row Filter
import raw CSV into DB
DB Writer
day month year
Column Combiner
create table airport_dim
DB Table Structure Creator
load dimension airline
DB Writer
drop useless columns
Column Filter
connect to postgresql
PostgreSQL Connector
create table time_dim
DB Table Structure Creator
check airline join
Joiner
read flights.csv
CSV Reader

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: marcel
Created at: 2025-09-01
On NodePit since: 2026-10-08
Last update: 2026-10-12
Created with KNIME version: v5.12.0

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

Try NodePit Runner!