Icon

data aggregation

Summarizing Booking Revenue per User with Row Aggregator

Conditional Running Totals for Points Transactions with Row Aggregator

Genre-Based Booking Counts with GroupBy

Time-Windowed Revenue by Gateway with GroupBy

Time-Series for Scanned Tickets

Statistical GroupBy for Review Sentiment by Genre with GroupBy

Reshaping Food Sales by Item with Pivot

Multi-Level Pivot for Review Ratings by Genre and Role with Pivot

Multi-Dimensional GroupBy for Seat Utilization by Screen and Show Time with GroupBy

SANIA TANWEER

RA2311003010872

CLASS: CLS 919

DATA MERGING LAB

Read showseat.csv
CSV Reader
Convert string booking_datetimeto date time
String to Date&Time
Remove any duplicatebookings
Duplicate Row Filter
Read seat.csv
CSV Reader
Readbooking.csv
CSV Reader
Join with userfor User Info
Joiner
Bar Chart
Readuser.csv
CSV Reader
Remove Userswith nophone & email
Row Filter
Convert string booking_datetimeto date time
String to Date&Time
Remove any duplicatebookings
Duplicate Row Filter
Readbooking.csv
CSV Reader
Calculate 1. Number of bookings2. Total Revenue3. Average Ticket priceper Genres
GroupBy
Rename Derived columns
Column Renamer
Join show tablefor connectingmovie table
Joiner
Join movie table
Joiner
Read foodorderitem.csv
CSV Reader
Calculate1. Number of bookings2. Total Revenue3. Average Ticket Price4. Average Movie Ratingper Movie
GroupBy
Rename Derived columns
Column Renamer
Calculate TotalSpends bya User
Row Aggregator
Read pointstransaction.csv
CSV Reader
Convert to Date&Time
String to Date&Time
Convert Rating Data Type
String to Number
Remove duplicatemovie
Duplicate Row Filter
Renamecolumns
Column Renamer
Enriches reviews with movie genre
Joiner
Extracthour
Date&Time Part Extractor
Associates each review with its related cast
Joiner
string todate time
String to Date&Time
Compute occupied
Expression
Remove Duplicate Movies
Duplicate Row Filter
inner joinresult + Screens on screen_id
Joiner
Calculate Statistics
GroupBy
Categorizes each showtime to morning, afternoon, evening
Expression
average rating across combined dimensions
GroupBy
Fill Missing Ratingas Mean
Missing Value
Creates a cross-tab structure summarizing average review ratings across roles and genres
Pivot
Joiner
Remove duplicatemovie
Duplicate Row Filter
Read movie.csv
CSV Reader
Calculate SentimentScore
Expression
Read ticket.csv
CSV Reader
Creates a binary indicator for whether each ticket has been scanned
Expression
string todate time
String to Date&Time
Extractmonth &year
Date&Time Part Extractor
Convert stringtodate time
String to Date&Time
Convert Rating to Decimal
String to Number
Remove any duplicatebookings
Duplicate Row Filter
Read show.csv
CSV Reader
Renamecolumns
Column Renamer
Summarizes total scans and total tickets per delivery method and month
GroupBy
Rename derivedcolumns
Column Renamer
Read review.csv
CSV Reader
Bar Chart
string todate time
String to Date&Time
string todate time
String to Date&Time
CSV Writer
Bar Chart
Excel Writer
Read payment.csv
CSV Reader
Convert transaction_datetime to KNIME Date/Time
String to Date&Time
Report PDF Writer
Component
Adds descriptive gateway information
Joiner
CSV Writer
Ensures only successful transactions contribute to revenue calculations
Row Filter
Report Template Creator
Readpaymentgateway.csv
CSV Reader
keep only paymentslinked to valid bookings
Joiner
Extract month& year
Date&Time Part Extractor
Calculate1. Monthly Revenue2. Average Amount/ Transactions3. Successful transactions
GroupBy
show.csv
CSV Reader
Fill Missing valuesas Mean
Missing Value
Rename Columns
Column Renamer
Read movie.csv
CSV Reader
Convert rate to decimal
String to Number
Remove MissingValues
Missing Value
Read fooditem.csv
CSV Reader
Read fooditemsize.csv
CSV Reader
Based on the FooditemPivot the Sizesand get the quantity of the orders
Pivot
RenameDerived Columns
Column Renamer
Join foodorderitem& fooditem on item_idto get the Item data
Joiner
Join the orders & items with the size tableon size_id
Joiner
Read review.csv
CSV Reader
Convert Rating to Decimal
String to Number
Read moviecast.csv
CSV Reader
Missing Value
RenameDerived Columns
Column Renamer
Read movie.csv
CSV Reader
Fill Missing Ratingas Mean
Missing Value
Read screen.csv
CSV Reader
Readbooking.csv
CSV Reader
inner join result + Seats on seat_id
Joiner
Aggregates occupancy at a two-level hierarchy
GroupBy
Pivot
Split Rows basedon either PointsPurchased or Earned
Row Splitter
Row Aggregator
Convert todate and time
String to Date&Time
inner join Showseats + Showson show_id
Joiner
Row Aggregator

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: Shagun
Created at: 2026-06-09
On NodePit since: 2026-06-09
Last update: 2026-06-09
Created with KNIME version: v5.8.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!